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... 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... B4A Question How to use DBUtils.DeleteRecord(Starter.SQL1,"Students", !?) - Theera    Dec 23, 2020 ", "Smith" & i)
ListOfMaps.Add(m)
Next
DBUtils.InsertMaps(Starter...
WebView1.LoadHtml(DBUtils.ExecuteHtml(Starter.SQL1,"SELECT , || ' ' || As Name From... B4A Question error trapping in DButils - peacemaker    Nov 18, 2020 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... B4A Library extDBUtils - Guenter Becker    Jul 8, 2021   (12 reactions) Warm welcome to the audiance I hope you are well.
Since Erel published DBUtils development... be polished up to get better? Every time I am using DBUtils I have to develop addional functionality... B4A Code Snippet DBUtils: clear table (delete all) - peacemaker    Nov 7, 2018   (4 reactions) '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... B4i Question [B4X] DBUtils2 - CreateTable not standardized - Alexander Stolte    Jul 17, 2020 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... Wish B4X DBUtils.b4xlib set the HtmlCSS variable as Public - klaus    Feb 25, 2020 In the documentation, for ExecuteHtml, we have : The style of the table can be changed by modifying HtmlCSS variable.
89147
But, the HtmlCSS variable is set Private in the DBUtils.bas file.
Can you please set it to Public.... Page: 1   2   3   4   5   6   |