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

Latest version available here: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/ This example demonstrates how DBUtils module can be used in B4J. DBUtils was modified to match the slightly different API of B4J jSQL library. Other changes: - ExecuteSpinner and ExecuteListView were removed. Instead there is an ExecuteList methods that can be used with ComboBox and ListView. - ExecuteHtml was removed. Currently there isn't a node similar to WebView in B4J (it will be added in...

Latest version available here: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/ B4i implementation of DBUtils: http://www.b4x.com/android/forum/threads/8475/#content http://www.b4x.com/basic4android/images/SS-2014-11-06_16.31.38.png DBUtils v1.10 - CreateTable now accepts two lists instead of a map for the columns and their types. The reason for this is that maps in B4i do not preserve the order and the order of columns can be important. Note that the updated CreateTable sub...

remotely (without downloading big SQLite db file). So, i have combined 2 DBUtils modules: latest DButils2 from Erel: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280 module with MySQL additions: https://www.b4x.com/android/forum/threads/module-universal-dbutils.80569/ It's not so good... If End Sub 'usage: DBUtils2.SetEscapeChars(True) DBUtils2.InsertMaps(db.SQL, "sorting...

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

if, like me, don't remember the position of the table fields in the array of string when use executememorytable , put the array strings into a map with table fields names. private Sub MakeMap(tables() As String,selections() As String,dati() As String) As Map Dim retmap As Map retmap.Initialize Dim tpl As Int = 0 For i = 0 To tables.Length-1 Dim l As List = DBUtils.GetFieldsInfo(Main.DATABASE,tables(i)) For n = 0 To l.Size - 1 Dim sfo...

I've originally posted this under the B4J Tutorial DBUtils Example. I've been asked....01 of DBUtils as posted in the B4J Tutorial forum. I'm re-posting my content below (originally.... ==== Original post: @ThRuST Just for fun (it's Friday) I modified DBUtils and the example that @Erel provides here -> (https://www.b4x.com/android/forum/threads/dbutils-example.34611/) In both the demo and DBUtils.bas, the modifications were minor in order to accommodate MySQL. Summary of DBUtils...

Hi all, i've a problem with DBUTILS library when use insertmap or deleterecord (use 2.11... End If Next Dim recs As List recs.Initialize recs.Add(rec) DBUtils.InsertMaps...
link: thanks @udg i go to see the OliverA solutions....
link: Hi @moore_it I hope you solved the problem yourself while looking at DBUtils code. I didn't...
link: Good idea, try now ! Thanks...