Need SQL tutorial

S

susu

Well-Known Member

Licensed User

Longtime User

• Nov 28, 2010

• #2

I need it too!

 

Upvote 0

moster67

Expert

Licensed User

Longtime User

• Nov 28, 2010

• #3

try this one as a starter:

http://www.b4x.com/forum/38522-post4.html

 

Upvote 0

tremara1

Active Member

Licensed User

Longtime User

• Nov 29, 2010

• #4

sql sample test

I copied the code into a project added a ref to sql lib and then changed the dir to file.DirAssets but the app is unable to open the db. Does it have to be on the DirDefaultExternal directory?

Trevor
Ballarat
Victoria
Australia

 

Upvote 0

S

susu

Well-Known Member

Licensed User

Longtime User

• Nov 29, 2010

• #5

It's Basic4ppc code, is it ok with Basic4Android?

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Nov 29, 2010

• #6

Hi susu,

It is a B4Android code and NOT a B4PPC code ?

Attached a slightly modified version of Erel's code that shows the query in a ListView view rather than in the Log file. I tested it with the emulator.

Best regards.

 

Attachments

• TestSQL.zip

  6 KB · Views: 558

Upvote 0

S

susu

Well-Known Member

Licensed User

Longtime User

• Nov 29, 2010

• #7

Thanks Klaus for your very useful code

 

Upvote 0

Cableguy

Expert

Licensed User

Longtime User

• Nov 29, 2010

• #8

Thanks all for the help...second Android project on the comming:sign0060:

 

Upvote 0

tremara1

Active Member

Licensed User

Longtime User

• Nov 29, 2010

• #9

sql not playing nice

I am still having an issue getting this sql test to work. I have used the code as is and still get a message that the "unable to open database" message in the sql initialise line. The sql library version I have is dated 31/10/2010. Sorry to be a pest but I use sql a lot.....thanks

Trevor
Ballarat
Victoria
Australia

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Nov 29, 2010

• #10

Could you post your code.

My SQL files are
SQL.xml 31.10.2010
SQL.jar 21.11.2010

Best regards.

 

Upvote 0

BPak

Active Member

Licensed User

Longtime User

• Nov 29, 2010

• #11

http://www.b4x.com/forum/basic4android-getting-started-tutorials/6690-text-files.html

File.DirAssets
The assets folder includes the files that were added with the file manager. These files are read-only. You can not create new files in this folder (which is actually located inside the apk file).

Click to expand...

 

Upvote 0

tremara1

Active Member

Licensed User

Longtime User

• Nov 30, 2010

• #12

Steep learning curve

My problem was I had not set up the sd card in the emulator properly...I had not used it before so had not noticed. Sorry to have bothered you...

Trevor
Ballarat
Australia

 

Upvote 0