Search Results

DBUtils is a b4xlib with useful utilities related to the SQL library. It is designed to work with SQLite databases. There have been three versions of DBUtils, one for each platform (except...
link: You should NOT use the program files folder for Additional Libraries. It is a restricted path. Choo...
link: I have done this, You should NOT use the program files folder for Additional Libraries. It is a re...
link: You don't need the bas file. Mark the library and the module will be included in your project....

Latest version available here: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/ The DBUtils code module is designed to help you integrate SQLite databases in your program. It contains...) Next DBUtils.InsertMaps(SQL, "Students", ListOfMaps) - UpdateRecord: Updates..., "1234") WhereFields.Put("test", "test #5") DBUtils.UpdateRecord(SQL... As JSONGenerator 'Requires a reference to the JSON library. gen.Initialize(DBUtils.ExecuteJSON(SQL...

The modified SQLCipherB4A library found here is not working with DBUtils. To reproduce, download the example in post #4, then Add DBUtils library then add after the necessary initialization is done...
link: The things is you cant use any DBUtils functions that accepts SQL argument like DBUtils...
link: I dont see the code that causes the crash. Try this... The crash happens to the DBUtils methods...
link: Sorry, I don't understand. Why would I need to include logs in my code? I'm fine. Everythin...

Hey, on B4A we need a map of the fields and types and on B4I we need 2 lists? DBUtils.CreateTable(main_sql,"mytable",CreateMap("id":DBUtils.DB_INTEGER),"id") That makes...
link: You should use DBUtils2: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280...
link: You are correct... It got evolved like this from the two older, platform specific, DBUtils...
link: B4A: 97283 B4I: 97284...

Hi My database copy each time when i run application. Records delete. How can i copy database just once if no exist . I tried with CopyDBFromAssets but seems i don't know how to use. DbPath=DBUtils.CopyDBFromAssets("mydata.db") sql.Initialize (DbPath, "mydata.db", True) ...
link: Hi, You can try: Sub Activity_Create(FirstTime As Boolean) ' Starter.SysDirApk = File.DirDefaultExternal Log("Data Folder: " & Starter.SysDirApk) ' If ...

screen example. DBWebView A database table in a WebView with a modified DBUtils version... module DBUtils The modified DBUtils module If you run Calculator and Calculator1 on a 480 x...

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 module. I noticed Erel used this: If cur.NextRow = True - in other methods to determine if (rows > 0... message_mast where mast_id = "&id ' the query If DBUtils.HasRecords(Starter.SQL1, q...

'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 Sub 'Deletes all the records of a table Public Sub ClearTable(SQL As SQL, Ta...

", "Smith" & i) ListOfMaps.Add(m) Next DBUtils.InsertMaps(Starter... WebView1.LoadHtml(DBUtils.ExecuteHtml(Starter.SQL1,"SELECT , || ' ' || As Name From...
link: =" &Csr.GetInt("ID") ,False) DBUtils.DeleteRecord(SQL1,"Students"...
link: It should be: DBUtils.DeleteRecord(Starter.SQL1, "Students", CreateMap("Id"...
link: It should be: DBUtils.DeleteRecord(Starter.SQL1, "Students", CreateMap("Id"...

ftype = DBUtils.DB_TEXT Else If fvalue.Contains(".") Then ftype = DBUtils.DB_REAL Else ftype = DBUtils.DB_INTEGER...(i) If isNumber3(fvalue) = False Then ftype = DBUtils.DB_TEXT Else If fvalue.Contains(".") Then ftype = DBUtils.DB_REAL Else ftype = DBUtils.DB_INTEGER End If End If ft.Put(field, ftype...