Android Question .

[wheretheidivides]

.

 

[margret]

I don't know if it will help you, but I have written a DataBase class that may be easier for you to use. It does not have the power and all features of SQL but it works. It's at the link below. The Docs are in the Class and there is also Demo code.

http://www.b4x.com/forum/additional-libraries-classes-official-updates/22118-class-databases.html

 

[mangojack]

wheretheidivides .. I'll vouch for Margarets db class ,which I'm currently using for quite a substantial recordset. (Thanks Margaret ... )
I have tried to go sql and dbutils and failed on various attempt's.
Having used Vb's random access files for many years, It was a comfort to find Margarets db Class.

Cheers mj

 

[mc73]

I think you should firstly go through a SQLITE tutorial (google this), and then use it inside b4a. Everything would be much clearer, since in b4a what you are using is execQuery and execNonQuery and cursors, all fundamental parts of sqlite (and sql in general).

 

[margret]

I wrote this on a 7 inch tablet and on a smaller screen like a phone I am sure it will not display correctly. I got your PM and will send some code later today.

 

[mangojack]

wheretheidivides ..

I've been having another search because its something i want to learn, but really struggle with the over the top complexity of most tutorials. Heres one you might find interesting.
Another of their sites enable me to learn the basics of html.

SQL Tutorial

Cheers mj