sql issue

W

WZSun

Member

Licensed User

Longtime User

• Jan 4, 2011

• #2

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

 

Upvote 0

tremara1

Active Member

Licensed User

Longtime User

• Jan 4, 2011

• #3

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...

 

Upvote 0

gjoisa

Active Member

Licensed User

Longtime User

• Jan 5, 2011

• #4

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

 

Attachments

• TestMySql.zip

  5.8 KB · Views: 349

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jan 5, 2011

• #5

What error do you get?

 

Upvote 0

tremara1

Active Member

Licensed User

Longtime User

• Jan 5, 2011

• #6

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.

 

Last edited: Jan 5, 2011

Upvote 0

gjoisa

Active Member

Licensed User

Longtime User

• Jan 6, 2011

• #7

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

 

Upvote 0

gjoisa

Active Member

Licensed User

Longtime User

• Jan 6, 2011

• #8

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:

 

Upvote 0

tremara1

Active Member

Licensed User

Longtime User

• Jan 8, 2011

• #9

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

 

Upvote 0

gjoisa

Active Member

Licensed User

Longtime User

• Jan 8, 2011

• #10

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

 

Upvote 0