Search Results

This new library is used to add some functions to the already precious SQL library. Insertion, updating and reading of images in fields of type BLOB. Functions to add a table, a field. Update a field. Delete a row or table. List of tables, fields and typos of the fields contained in the database Co
link: :p:p:p Sorry, my english is bad... ehm also my italian...
link: PopOlate? Didn´t you mean populate? Note that you did this mistake a few times.

SQL Library is included in the installation. It is an internal library.
link: oh.. may I know where can i find it from ?
link: where can I download a SQL lite library for B4A from?

Basic Reading of Data: ' open connection using different method sql.OpenConnection2("jdbc:jtds:sqlserver://192.168.1.4/DR_MANAGER", "sa", "systemadmin") ' reading and looping result set Dim res As MSSQLResultSet = sql.ExecuteQuery("SELECT * FROM tblDRHeader") Do While res.MoveNext
link: BTW, I only have tried it to MS SQL Server. I havent tried it to other server database but if JTDS supports it (any database) then it should work.
link: Brilliant, keep it up! will definately test this out!!

IsInitialized As Boolean Verifica se l'oggetto sia stato inizializzato. NextRecord As String PreviousRecord As String Query (StringQuery As String, PrimaryKeyName As String) As String Query2 (StringQuery As String, StringArg As String(), PrimaryKeyName As String) As String RefreshField As String

I sometimes build long complex SQL statements from code, and it takes a lot of effort to code and test, so figured why not build a class to do it for me? Here's a very simple class (the example is in B4J) to build SQL statements from code. It consists of a very basic screen (only needed for the exa
link: Thanks Klaus, you're right - I left a file out of the zip. My apologies, it should be fixed now. I actually used B4J for my example (figured it would
link: How did you zip your project. It seems that it is a B4XPages project and you did not zip it as a B4XPages project. You should zip with this line in th

I'm currently using the SQLCipher library. It seems that this library also needs the SQL library to be loaded, even if the SQL library itself is not used in the B4A source code. Otherwise I get this error: class file for anywheresoftware.b4a.sql.SQL not found So I've added the SQL library. But now
link: The compiler doesn't know that SQL is needed. You can add: #IgnoreWarnings: 32 To the main module.

After some test I found the answer for my question. The SQL library is not compatible with database created with third-party software. I created a db with App, I copied the db from device to pc. Open the file with SQL Expert Lite (or other) Edit tables, create tables. Copied the modified file to b4

Library: TDDBUtils.b4xlib Language: B4A Version 1.8 Manual: Version 1.5.2 (did some checks and improvements, added SQLCipher tutorial) Status: Work in Process (C) This library is free for non commercial use other use see manual. New to 1.8: optimized code fixed some errors Added grouping and sorti
link: Thanks for this library. I think, this code on manual is wrong select1(TabName As String, Columns As String, Condition As String) As ResultSet The s

That documentation is for the SQL library. In this case we are talking about the JdbcSQL library -> https://www.b4x.com/android/help/jdbcsql.html - Colin.

SQL Library is using the already installed SQLite. I don´t think a new Version also installs a new SQLite on Android.
link: Yes, I think but I'm not sure if Erel can do this in a new version of the SQL library.

Powered by ColBERT