Android Tutorial SQLiteDB

klaus · Jan 6, 2012

To check, I just downloaded the zip file from the forum and the progam does work.
What did you change the code ?
Without knowing what you have done it is impossible to know what happens.

...why do you create all your windows in code not in the designer...

I partialy agree with you. Me too, I design my layout mostly in the Designer. But, depending on what you want or need there are adjustments that are easier made in the code (at least for me).
I find it easier making the adjustmets to fit different width/height ratios in the code rather than having another layout variant.
The filling of the scrollview panel for editing is made in the code because the number of columns can be different and this cannot be done in the Designer.
By the way, there are 8 layout files edited in the Designer but adjusted and completed in the code.

Best regards.

bekadata · Feb 14, 2012

Error occourred on 1280x800 lenovo

Hi Klaus,
when I run SQLiteDB on my lenovo thinkpad tablet, I get:
Error occured
An error has a
occured in sub:main_skbscroll_valuechanged
(java line:3403)
java.lang.RuntimeExeption: Object should first be initialized
(Panel).
Continue?

If I push 'yes' everything are working fine, until I turn the tablet horizontal or
vertical . Then the same msg.
On my HTC Desire, I can turn as much as I like without any problem.

Anyway, thanks for SQLiteDB. It is a great program itself and very usefull as inspiration to other specialized programs.
Bent Karlsen

klaus · Feb 14, 2012

Unfortunately I can't test it, I don't have a tablet.
But you can remove the skbScroll Seekbar.
The program has two means to scroll horizontally, pnlScroll and skbScroll.
pnlScroll is more dynamic and shown by default.

The only reason I see is that when changing skbScroll.Value the skbScroll_ValueChanged event is raised (in the tablet but not on a smartphone), in that case pnlHeader is not yet initialized.

Try the new version of the program in the first post.

Best regards.

bekadata · Feb 14, 2012

Error occourred on 1280x800 lenovo

Thanks for the very quick responce, Klaus.
The problem is still in the 1.1 version, but I removed the skbScroll as you sugestede and everything is running fine.
And, if you need something to be tested on a tablet in the future, I will be more than happy to help.
regards Bent

StevetheCanuck · Apr 12, 2012

Hi Klaus,

Is there an easy way to copy a sqlite database into the emulator and open it with your program?

TIA
Steve

klaus · Apr 13, 2012

Yes, you can copy a database to the Emulator.
Look at the Beginner's Guide Edition 2.1 chapter 6.4 Exchange files with PC.
Make sure the the Emulator is setup with SD card support chapter 6.2 Create a new Emulator.
Then in the program you can load the database clicking on the Load button.

Best regards.

JTmartins · Feb 7, 2013

Error here

Hi there,

I would like to learn a little from this, but when running in release mode I got an error.

So I've tryed in debug mode and I get :

An error has accurred in sb:main_activity_resume (B4A line 262)
pnlScroll.top=100%y-pnlScroll.Height
java.lang.RuntimeException : Object should first be initialized (panel).

Any help ?

Thanks

José

B4A 2.5

Erel · Feb 8, 2013

I'm not really familiar with this example. However this error means that you are accessing an uninitialized panel. If this panel was added with the designer then you should make sure that the layout was loaded (and not only when FirstTime is true).

klaus · Feb 8, 2013

Yes it's an error.
I have updated the zip file in post #1.
pnlScroll doesn't exist in this example, it did exist in the versions without the ScrollView2D object and I forgot to modify the the landscape orientation.

Best regards.

KiloOne · Feb 9, 2013

Hello Klaus,

This is a great demo program!! :sign0098:

I am however trying to run it on an 800x440 scale .75 android and am having some problems.

First, the button text was too big for all buttons so in designer I created new layout variants for all layouts at 1066x592 scale=1, I then changed all textsize 14 to 10 etc.

Second, I had to change this:
pnlColumnSetupTools.Left = ScreenWidth
to this:
pnlColumnSetupTools.Left = ScreenWidth - pnlColumnSetupTools.Width
if screen is landscape. Don't think that was scale related.

Next I have noticed 2D scrolling not working and I think it is related to the same scale=.75 issue but I am not sure how to solve that, is there a global way to fix the scaling of scvList to solve this?

Also, the header Left setting does not place the header correctly when I click on a column sort, this is also related to scale=.75 (I think) and have not sorted this out yet either.

Any help would be appreciated.:sign0104:

Thanks,
Dale

klaus · Feb 9, 2013

800x440 scale .75

What kind of device is this ?

In the first post you find an updated version.
- 2D scrolling OK
- header left OK you can comment out lines 755 and 756

Best regards.

KiloOne · Feb 9, 2013

Wow, thanks a lot, 2D scroll fixed now and I remmed out 755 and 756.

What is the best way to fix the textsize on the buttons and labels in v1.3 as the v1.3 text on the labels/buttons is too big for their views (should i do it like I explained in my first post to you?).

This is a $70 Chinese 7" A13-MID Ebay tablet. Very impressive for the money!

Sorry, it is 800x444 scale=.75.

Thanks,
Dale

klaus · Feb 9, 2013

You have at least two solutions:
- use a specific layout
- try to use the AutoScale module, I haven't tryed with a 0.75 density.

Best regards.

KiloOne · Feb 9, 2013

Klaus,

I am new so forgive my ignorance.

I added your scale module to the v1.3 project and I added these lines after all the layout.addview's in Sub Activity_Create:

Scale.SetRate(.33)
Scale.ScaleAll(Activity, True)

It seems to work, just want to confirm that is what you suggested. If this is the case would it not be useful to have that there for all devices with the .33 replaced by some formula based on scale of the device (.75 in my case)), perhaps (1/scale)-1. I tried -.2 in setrate and negative number worked (buttons got smaller) so a scale 2 device would setrate(-.5).

And, to me the column sorting indicators (up and down arrows) are confusing.

I expected that I should only see only one up or down arrow in the whole header which indicates the current sorted column and its sort order.

What I see is every column always has an Up or down arrow beside it. Is this intentional?

Thanks,
Dale

BTW I think in Column Setup you may have Row Height setting Col width and Col width setting Row height

klaus · Feb 9, 2013

...just want to confirm that is what you suggested.

Yes.
You can play with the ScaleRate value.

Best regards.

KiloOne · Feb 9, 2013

Sorry I was editing while you replied

klaus · Feb 11, 2013

If this is the case would it not be useful to have that there for all devices with the .33 replaced by some formula based on scale of the device ...

When you set a scale ratio two scale factors are calculated one for X and one for Y depending on the screen size, resolution and density.
With a ScaleRate of 1 the result is the same as dimesioning with 100%x and 100%y.
For your device and in portrait
with Scale.SetRate(1) gives sacleX = 2 and scaleY = 2.36
with Scale.SetRate(.33) gives sacleX = 1.33 and scaleY = 1.45
To make the program look OK it would need some rearangements when using it with the Scale Module. The program was written before Erel added the DesignerScripts and AutoScale function.

In my mind the up and down arrows show the direction for the next sorting for each column and not the last sorted column. But feel free to change it to your convenience.

Did you have a look at the SQLExample program in the User's Guide ?

Best regards.

KiloOne · Feb 11, 2013

Thanks for the extra insight into scaling. The fact that scalex and scaley can be different certainly enhances the power of GUI development but at some cost of head scratching. Fortunately my current project will only be written for this android screen and for now I will unfortunately have to delay my knowledge expansion in this area.

Sounds like I should begin with Designer scripts and autoscale in mind though.

At this point using Scale.SetRate(.33) with your Scale module allows me to use this SQLiteDB example to gain the knowledge I need to continue.

Looks like the SQLExample Project in the user guide is very similar to the sample poject of this thread. Do they have the same beginnings?

Again, great sample code for many things!:sign0142:

Dale

P.S. If you don't mind, how does one insert what looks like extended ascii characters into the code (eg the up/down arrows you use in the header) and where do I find a table showing the available characters?

klaus · Feb 13, 2013

Looks like the SQLExample Project in the user guide is very similar to the sample poject of this thread. Do they have the same beginnings?

The SQLExample is more recent and works with different Activities instead of different Panels in the same Activity. The two are quite similar.

... and where do I find a table showing the available characters?

I use the Windows Character table tool.
On my computer it's C:\Windows\System32\charmap.exe

Best regards.

KiloOne · Feb 13, 2013

klaus said:
I use the Windows Character table tool.
On my computer it's C:\Windows\System32\charmap.exe

WOW, wish I knew this long ago!

Thanks,
Dale

Android Tutorial SQLiteDB

Attachments

Expert

New Member

Expert

New Member

New Member

Expert

Active Member

B4X founder

Expert

Member

Expert

Member

Expert

Member

Expert

Member

Expert

Member

Expert

Member