Android Question multiplatform data base code

[developer_123]

I want to know if there is any code multiplatform to use data base ( for example .db) . I'm was searching inside the forums and, for each platform I found diferents codes, is say all can use sqlite but each one with a diferent library (I'm not found b4x SQLite library), and the only common that I found is the b4xtable, but this is only for a just one table. Someone can tell me if exist any metod or b4x library that can be use databases with the same code estructure to use in B4a, B4i and B4J.

Thanks!



I appreciate your comments!

 

[aeric]

The SQL library for 3 platforms are equivalent. They are just name differently as SQL, iSQL and jSQL.

[B4X] SQL with Wait For

The new resumable subs feature, introduced in B4J v5.50, B4i v4.00 and B4A v7.00 (to be soon released), makes it simpler to work with large data sets with minimum effect on the program responsiveness. The new standard way to insert data is: For i = 1 To 1000 sql.AddNonQueryToBatch("INSERT...

www.b4x.com

 

[developer_123]

Aeric thanks! initially I was conffused because in B4A works the variable Cursor but in b4J and B4i works with ResultSet, and I thought the same would happen with all others commands, but testing I realized that this have the same properties betwen three platforms

 

[aeric]

Aeric thanks! initially I was conffused because in B4A works the variable Cursor but in b4J and B4i works with ResultSet, and I thought the same would happen with all others commands, but testing I realized that this have the same properties betwen three platforms

Cursor is still supported (in B4A only) if I am not mistaken. As Erel suggested, we should use Resultset instead so the code can be shared among the 3 platforms.

 

[developer_123]

It is also possible to include the following code for the declaration and thus be able to use it on the 3 platforms:

    #if b4a
    Dim Cursor1 As Cursor
    #else
    Dim Cursor1 As ResultSet
    #end if

but is better use the same declaration ResultSet, not to be confused.

 

[aeric]

It is also possible to include the following code for the declaration and thus be able to use it on the 3 platforms:

    #if b4a
    Dim Cursor1 As Cursor
    #else
    Dim Cursor1 As ResultSet
    #end if

but is better use the same declaration ResultSet, not to be confused.

If you use Resultset then you don't need this.
Just write something like this:

Dim Res As ResultSet

 

[LucaMs]

https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/#content

?

 

[Erel]

Please don't make duplicate posts. As I wrote in the other thread and as aeric wrote, you should never use Cursor. Only ResultSet.

 

[developer_123]

Thanks Erel, is right, only ResultSet !