B4J Library [B4X] DBUtils 2 - Erel    Dec 16, 2021   (36 reactions)   tags: DBUtils, 2, sqllite, myapp, db, B4X DBUtils 2 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... B4A Tutorial DBUtils - Android databases are now simple! - Erel    Jul 3, 2017   (14 reactions)   tags: DButils, SQLite, DB 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... B4J Tutorial DBUtils Example - Erel    Mar 30, 2018   (9 reactions)   tags: Erel 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... B4i Library [module] DBUtils - Erel    Jul 3, 2017   (1 reaction) 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... B4J Code Snippet [SQL] DButils v.2.5 for SQLite and MySQL - peacemaker    Oct 11, 2023   (4 reactions) 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... B4J Code Snippet DBUTILS.executememorytable return a map - moore_it    Jul 5, 2022   (1 reaction) 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... B4J Library [module] (Universal) DBUtils - OliverA    Jun 12, 2017   (9 reactions)   tags: MySql Tool DBUtils 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... B4J Question DBUTILS and mysql problems - moore_it    Feb 18, 2022 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... B4A Question DbUtils.CopyDBFromAssets Android - ykucuk    Jul 14, 2021 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)
... B4A Code Snippet DBUtils 2 - New Method - HasRecords - Harris    Jan 18, 2019   (3 reactions) 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... Page: 1   2   3   4   5   6   7   |