I use one sub with code attached below that suppose to fill a list with a B4XTable rows.
It works great, but if accidentally I have clicked on "Recents" button on the phone while the code is in the "Do While rs.NextRow " loop the app will crash with the error listed below.
Not sure what would...
Hello everyone,
In the code below, when I extract datas from a table, I find a special behaviour decribed here:
The log renders the good answers for two datas LAT and LON, but if I try to put them in two EditTexts, the result is 0.
Do I miss something ?
Thanks
Noticed that after closing a ResultSet (closing the ResultSet and freeing resources) the RowCount remains as before closing the ResultSet. As I have a number of module level ResultSets that remain open I added a Sub to keep track of these and close all open ResultSets if there was a memory...
I have a strange problem (only on any smartphone) when i try to get value from resultset when inside result set i keep the blob column.
android.database.CursorIndexOutOfBoundsException: Index -1 requested, with a size of 1
at this point
dim value as string = rst.GetString2(0)
or for blob
Dim...
While converting my code (to make compatible with A, i, J) from using:
Private Cursor as Cursor
--- to:
Private Cursor as ResultSet
I found the need to determine if the dataset has any rows... (like: Cursor.RowCount - which does not exist in ResultSet).
I added this method to my DBUtils...
Hello.
Is it necessary to call the "close" method on a database once we're done with it?
What about result sets? Is it necessary to close them?
Thanks in advance.
dbutils
'version 1.20
Sub Process_Globals
Type dbOptret (success As Boolean,msg As String)
Public conpool As ConnectionPool
Private curDbType As Int=0
Public DB_REAL, DB_INTEGER, DB_BLOB, DB_TEXT As String
DB_REAL = "REAL"
DB_INTEGER = "INTEGER"
DB_BLOB = "BLOB"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.