sql issue

[gjoisa]

I have a sql database named "Atlas.sl3" , created with B4PPC . In that db I have 9 columns called Field1 Text , Field2 Text ,...... Here in B4Android method used is Col1 Text , Col2 Text . Can the same database can be used here ? While trying I failed to use . .sl3 file can be valid extension or .db should be used ?
And Field1 , field2 can be used ?

 

[WZSun]

Hi,
I used the same sql database file in B4PPC and B4A. Use the same column field names and table names. Make sure you define them as before, Field1 Text, etc.
There is no restriction on the filename or extension. It can be .db, .usr, .sl3 or whatever.

Rgds

 

[tremara1]

I have another example

This is an example of the use of sqllite db...might give you some ideas...
http://www.b4x.com/forum/basic4android-share-your-creations/6998-family-med-list.html hope it helps...

 

[gjoisa]

Here I am attaching my project . i could not find why this is not working ?

 

[Erel]

What error do you get?

 

[tremara1]

no db file

It looks as though the db is not in DirAssets which should be the "files" folder where your app is. Also a typo in the if statement where you are checking if the db exists, "Atls.sl3" should be "Atlas.sl3". Also you might want to add a listView to see your data. Hope this helps.....ps you should use the file manager via the files tab in your B4a UI to add the db.

 

[gjoisa]

After adding the Atlas.sl3 file through file manager also , I am getting an error "java.io.FileNotFoundException" .

 

[gjoisa]

Made some changes . Now it works in my device . Still not working in emulator .
I think it is because there is no sd card in emulator ???:BangHead:

 

[tremara1]

Might help with emulator sd card

I have made a little tool to help with creating the sd iso which you can then use with the emulator. I am not sure if you can add to a AVD you already have but you can just use the AVD Manager to create a new one with SD. Pls read the instructions and remember this tool needs to run administrator....Good Luck.
http://www.b4x.com/forum/basic4android-getting-started-tutorials/7240-avd-sd-card-maker.html#post41420

 

[gjoisa]

Nice app . Now it is working fine on emulator also . Thank you .