I'm trying to download and insert record in sql I'm inserting 250 records at a time with ExecNonQuery. sometimes while inserting records show...
Hello friends I'm in trouble I'd like someone to help me. I'm running a sql query with select sum () and select total () in the sqlite database...
SubName: N/A its simply a concept/idea that would appear very easy to implement, with possibly great benefits for performance. But totally...
https://www.b4x.com/android/forum/threads/error-with-customlistview.97829/ As per discussion in this forum I got that...
Hi to all, I'm building database structure in SQL, i want hold history of change in record in tables that have many to many relationship. Tables...
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...
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...
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?...
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,...
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...
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...
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...
Hello guys, I have the following SQL JOIN statement SELECT A.NamePerson AS "Person", B.NamePerson || " e " || C.NamePerson AS "Dads" FROM...
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...
The current AddNonQueryToBatch/ExecNonQueryBatch is very flexible by allowing various non-query statements (update, instert, delete, etc.) to be...
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...
