1. G

    Android Question [Solved][B4XTable] Crash in ResultSet if click on "Recents" phone button

    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...
  2. DALB

    Android Question Non correct extraction from SQLite (May be)

    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
  3. R

    Android Question ResultSet RowCount after Close

    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...
  4. uniplan

    Android Question Strange CursorIndexOutOfBoundsException

    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...
  5. Harris

    Android Code Snippet DBUtils 2 - New Method - HasRecords

    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...
  6. MegatenFreak

    B4J Question Necessity of closing databases and resultsets?

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

    B4J Code Snippet get col type exactly with dbutils(ResultSetMetaData)

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