dbutils

I am trying to make a backup of my database using Private Sub btnBACKUPDatabase_Click Dim dbd As String dbd = DBUtils.GetDBFolder Log(dbd) DBUtils.CopyDBFromAssets("SWSU.db") DBUtils.cop End Sub But the file I can access (via my PC) only seems to show the records in the tables as they were...

One my project has to be using not only SQLite database (actually, two different ones, as separate classes), but MySQL also, due to big size that now is more convenient to see via web-browser remotely (without downloading big SQLite db file). So, i have combined 2 DBUtils modules: latest...

Lectori Salutem, I've run into this oddity where a tableview crashes after it has been reloaded exactly 100 times. It's no use to do it in a loop, that doesn't refresh the table properly but when you click the button 100 times and let the table reload properly the app crashes (not joking)...

Warm welcome to the audiance I hope you are well. Since Erel published DBUtils development of database driven app has become much easier. Very good job done! But who says that good work could not be polished up to get better? Every time I am using DBUtils I have to develop addional...

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

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

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

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

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

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

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

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