Need SQL tutorial

[Cableguy]

Any one available?

 

[susu]

I need it too!

 

[moster67]

try this one as a starter:

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

 

[tremara1]

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

 

[susu]

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

 

[klaus]

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.

 

[susu]

Thanks Klaus for your very useful code

 

[Cableguy]

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

 

[tremara1]

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

 

[klaus]

Could you post your code.

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

Best regards.

 

[BPak]

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

 

[tremara1]

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