sql

Hello. I'm writing an app that allows several computers to add new orders to the database. To avoid any conflicts, I want to make sure that when one system is adding a new list of orders, no others can interrupt and will have to wait for the first one to finish up. I understand that the most...

Ola I need a wizard please *no pun intended. Lets say you have a SQLite db, you want to access this thing from a webapp (no websockets/no server), it should be embedded inside your web app. One approach is to convert this thing into a js file including the CREATE scripts, data etc and perhaps...

Hello. Is it necessary to call the "close" method on a database once we're done with it? What about result sets? Is it necessary to close them? Thanks in advance.

Hello, for example: log(cursor1.GetBlob("pic").length) the ".length" is not displayed in the preview and if I want to print this through the log, then this error comes: Error occurred on line: 2344 (Main2) java.lang.NullPointerException: Attempt to invoke virtual method 'boolean...

Hello guys, I know this may not be the correct place to put this question but, since many of you have more SQL knowledge than me, I'll give it a try... I have this test FamilyDb SQLite database (attached), I adapted the following query from an example I saw and it works fine to list DECENDANTS...

Hello Guys, I'm loading a spinner from SQL database but I'd like to have the very 1st spinner element as NULL (or space) and give the chance the user to pick up NULL if none of the existing values applies to him. What is the best aproach? To have DBUtils.ExecuteSpinner load spinner and then...

Hi guys !!! Is there any way ( through the SQL library) to obtain the number of records affected by an UPDATE transaction over a database? ( no matter if it's Oracle|SQLite|MySql|etc...) without querying the database. Thanx in advance. Javier

Hello guys, I have the following SQL JOIN statement SELECT A.NamePerson AS "Person", B.NamePerson || " e " || C.NamePerson AS "Dads" FROM Persons A LEFT JOIN Persons B ON A.CodMom = B.CodPerson LEFT JOIN Persons C ON A.CodDad = C.CodPerson ORDER BY A.NamePerson That works fine...

So I am currently working on a b4i app that is having some issues when trying to merge two db3 files. The files are supposed to merge by downloading the latest file from a server and then migrating the data from that new file to the old one. However since changing how files are downloaded an...

The current AddNonQueryToBatch/ExecNonQueryBatch is very flexible by allowing various non-query statements (update, instert, delete, etc.) to be batched together. But often, it is just one type of non-query statement that needs to be executed multiple times. Even the example given for...

This is a first version of the BindingNavigator Library, which wants to somehow reproduce the corresponding BindingNavigator of VB.NET What is needed? I want to get something similar to the tools available on VB.NET to link the views to the DB. As in the pictures. I am now working on a B4J App...

This new library is used to add some functions to the already precious SQLite 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...

This is a first version of the BindingNavigator Library, which wants to somehow reproduce the corresponding BindingNavigator of VB.NET. What is needed? I want to get something similar to the tools available on VB.NET to link the views to the DB. As in the pictures. A DataSet Class is...

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