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 of B4R). DBUtils v2.0 merges the three modules to a single module that is compatible with B4A, B4i and B4J. T
link: Unofficial B4X DBUtils v. 2.07 (Erel, please, check it and then use it or not and remove this post ;))
link: Hello, I'm a complete beginner in B4X and I'm following this tutorial (ro6nRwK-VaI:108). In the tutorial, they add DBUtils as a model, but it seems th
link: V2.01 is released with a fix related to the clickable html table. @Bob Spielen please update to v2.01. Make sure to return True from WebView1_Overrid

The library name is DBUtils.
link: I don't know what is B4XDBUtils. This is the correct library: DBUtils 2

DBUtils is a class. You can open the source code and add this piece of code (and others).
link: SubName: FieldExists Author: asales Description: checks if a column exists in a SQLite database Sub FieldExists(SQL As SQL, TableName As String, Tabl
link: Update. Thanks.
link: thank you for this. Nice one. Can you please update your post #1 to match the rules of this forum (using the right keywords)? It would be easier to f

Two comments: - Not all code paths return a value. - Utility methods or library methods should avoid catching errors (in most cases).
link: DBUtils is a code module. That does not handle events...
link: Thanks, Erel, but how to make sure that SQL's NonQuery is done without error ?
link: 'Tests whether the given table exists Public Sub TableExists(SQL As SQL, TableName As String) As Boolean Dim count As Int = SQL.ExecQuerySingleRes

Your post has got halfway down the second page of the forum without receiving any replies. That usually suggests that someone has asked an unanswerable question. We all know that DBUtils is a tried and tested module, so there must be a a bug in your code, of course. In this line ... DBUtils.Delete
link: Hello, I can't delete a record from the database through the code; Dim m As Map m.Initialize m.Put("codice", "VERDI") DBUtils.DeleteRecord(SQL, EtxNo
link: Thank you, Right now I found the problem, in fact it is absolutely in my code. when inserting the fields (taken from Ms Sql) the characters "filler" s

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 a set of methods for common SQL tasks. Issues like escaping strings and identifiers are handled autom
link: V1.20 is now available. The targetSdkVersion is set to 23. DBUtils uses RuntimePermissions.GetSafeDirDefaultExternal to get the path to a writable fol
link: DBUtils.InsertMaps(SQL1,"table2",Rowmap) Expects a List of Maps ! So you need to define a List and add the Map to it and then call DBUtils.InsertMaps
link: I am using the DBUtils eample and editing it for use in my app. I am attempting to change the id field in the students table to an alpha text string.

Always prefer the library, unless you need to customize the library code.
link: Hi, sorry, if someone asked this last time.? What should I use? DBUtils code module or the library? Thanks a lot for your answers. Best regards Ma

The other main issue you will run into when switching DB's is SQL syntax (see the concatenate above). This is not an issue of DBUtils itself (it uses pretty plain SQL), but the programmer must be aware of this issue when passing SQL statements to DBUtils. Please note, in the end this is a minor upd
link: Looks like your SQL object is not initialized. You need to make a database connection first. The SQL object behind that database connection then needs
link: java:38) at com.sun.javafx.application.LauncherImpl.lambda$launchApplication1$162(LauncherImpl.java:863) at com.sun.javafx.application.Platfor

Fixed in v2.06: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/#post-515104
link: I think I found the issue... In DBUtils v2.05, the Sub 'TableExists' reads: 'Tests whether the given table exists Public Sub TableExists(SQL As SQL,
link: Good day! I'm trying to create a conditional service on if a table exists. However, when I test for the existence of said table: If (DBUtils.TableEx

There was never a port of the layout. Maybe in the future. DBUtils is tailored for SQLite databases. You will need to make some modifications if you use a different database.
link: Latest version available here: https://www.b4x.com/android/forum/threads/b4x-dbutils-2.81280/ This example demonstrates how DBUtils module can be use
link: DBUtils will only work properly with SQLite databases. It requires some changes to work with other databases.
link: Btw I think Erel got a point by saying Modified DBUtils. Perhaps it should be called modDBUtils to not confuse it with the official DBUtils maintained

Powered by ColBERT