dbutils

  1. Mashiane

    B4J Question Is there a way around? DBUtils InsertMaps Transaction?

    Ola I'm adding multiple records to my sqlite db using DBUtils InsertMaps. This uses a transaction for the inserts. This works perfectly, however if there are records in your table that conflict with a primary key, even if there are new records in your INSERT statements, the whole transaction...
  2. peacemaker

    Android Code Snippet DBUtils: clear table (delete all)

    'Tests whether the given table exists Public Sub TableExists(SQL As SQL, TableName As String) As Boolean Dim count As Int = SQL.ExecQuerySingleResult2("SELECT count(name) FROM sqlite_master WHERE type='table' AND name=? COLLATE NOCASE", Array As String(TableName)) Return count > 0 End...
  3. peacemaker

    Android Question DButils: error-free JSON import into SQLite

    HI, All If we have HTTP API and get the JSON reply that should be saved into SQLite DB table - the API may be changed, extra fields can be added into JSON suddently... The SQLite DB structure is always fixed, so the task is to automate any JSON import (insert to or update the table), but only...
  4. FERNANDO SILVEIRA

    Android Question Have NULL as first element of an spinner loaded with SQL

    Hello Guys, I'm loading a spinner from SQL database but I'd like to have the very 1st spinner element as NULL (or space) and give the chance the user to pick up NULL if none of the existing values applies to him. What is the best aproach? To have DBUtils.ExecuteSpinner load spinner and then...
  5. FERNANDO SILVEIRA

    Android Question DBUtils... My database added to file assets seems not to be there

    Hello guys, I have a database (genealogy.db) that I'm trying to read and added it to my app assets using Designer tool files tab, however when I run the program I got the following message when during File.Copy(File.DirAssets, FileName, TargetDir, FileName): Logger connected to: samsung...
  6. mcqueccu

    Android Question DBUtils DBversion doesnt return user version set in Sqlite

    How to I set and Get correct DBVersion in SQL Browser and my application. From the sample code below, I get result as 1 meanwhile, in building the database, I set user version as 15. Screenshot below What am i doing wrong. Also included example project If...
  7. A

    B4J Question DBUtils.Execute... loads first row only

    Hello, I am a "beginner" with some DB experience 25 years ago in VB and thought I try to use B4X to bridge the gap to android tablets for my sheep program, which I try to convert to B4J first. I hope the members excuse the surely stupid simple problem being posted here. In my recent test I...
  8. J

    Android Question DBUtils NullPointerException when not using breaks

    Hi everyone! Ok, I keep getting this problem. I have a SQLite (edited) database in my project, and I use DBUtils (latest version) to communicate with it. If I run the code normally (pressing f5, even in Release mode), I get an error. But if I run it using breaks every couple of lines, or even...
Top