Android Question multiplatform data base code

developer_123 · Jan 13, 2021

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 · Jan 13, 2021

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 · Jan 13, 2021

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 · Jan 13, 2021

developer_123 said:
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 · Jan 13, 2021

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

B4X:

    #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 · Jan 13, 2021

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

B4X:

#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:

B4X:

Dim Res As ResultSet

LucaMs · Jan 13, 2021

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

?

Erel · Jan 13, 2021

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 · Jan 14, 2021

Thanks Erel, is right, only ResultSet !

Android Question multiplatform data base code

developer_123

Active Member

aeric

Expert

[B4X] SQL with Wait For

developer_123

Active Member

aeric

Expert

developer_123

Active Member

aeric

Expert

LucaMs

Expert

Erel

B4X founder

developer_123

Active Member

Similar Threads

Android Question multiplatform data base code

Active Member

Expert

Active Member

Expert

Active Member

Expert

Expert

B4X founder

Active Member

Similar Threads

Privacy & Transparency

Privacy & Transparency