Android Question .

margret

Well-Known Member

Licensed User

Longtime User

• Dec 31, 2012

• #2

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

 

Upvote 0

mangojack

Expert

Licensed User

Longtime User

• Dec 31, 2012

• #3

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

 

Upvote 0

mc73

Well-Known Member

Licensed User

Longtime User

• Dec 31, 2012

• #4

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

 

Upvote 0

margret

Well-Known Member

Licensed User

Longtime User

• Dec 31, 2012

• #5

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.

 

Upvote 0

mangojack

Expert

Licensed User

Longtime User

• Jan 1, 2013

• #6

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

 

Upvote 0