sql

Hello, I like to get a suggest of method, regarding best practices for my App : 1/ i have an SQLITE db that contain general setting strings and language strings for its operation, and independent of user data. I systematicaly copy that DB from asset dir to Internal, so even after app updating...

Colleagues, I'm pretty worried, I should do this migration from SQLCiper V1.50 to V1.60, as we all know from the 64BIT binary. The problem is generated because the database created in V1.50 will not be compatible with V1.60, so as I do to pass that data to the new database when updating the app...

Hello, I have a problem is that I do not understand at all how to "Block" an HTTP request because I use Wait For (Resumable). Look at the case: I select my items from my local database, and then I send the data to an API but they are not sent properly because, as it is a "non-blocking" event...

I am working on the SQL tutorial at https://www.b4x.com/android/forum/threads/sql-tutorial.6736/#content I seem to have pretty much understood the example project. Now I am modifying it to get to what I need. I have this grid showing data, a bit like a spreadsheet, and the user may modify one...

Hello everyone, My app is an ordering app, so the buyer contacts the seller and once the seller send the buyer a message and he is not online the app should send a notification. The problem : The notifications Not always are being sent and the services some times it works and sometimes it just...

Hi there, I want to share a tactic / a small guard for MySQL/MariaDB DataBases.. Well all we know that having a Database online and not in localhost is difficult to protect from brute force attacks / ransomware attacks... Well i ll give a little "pebble" to help others to think / different -...

Buenas, soy nuevo en este mundillo y tengo un problema con mi código. Expongo la situación: Estoy trabajando en una aplicación de listados de fallos. A través de una base de datos .db muestro en un list view los fallos. Mi problema es que cuando hago clic encima de un item del list view quiero...

Buonasera, vorrei col mio telefonino creare un app che mi permetta di farel' update di dati che ho su un database aziendale. Di solito su VB.net usavo laconnessione OLEDB o SQLclient esiste qualcosa di simile? Quindi una volta aperta la connessione fare le query, le update ecc in sql. Ho...

I have a long running app that I have updated over the years as things have changed but this error causes my sql_lite database to die and become corrupt. Basically failing when it updates a blob field in a SQL database file under Android 8.1 (Oreo) on Samsung tablets. Its not random and happens...

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 this log Error occurred on line: 656 (all) android.database.sqlite.SQLiteDatabaseCorruptException: database disk image is malformed (code 11...

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 and the result is rounding to a smaller one. code: conect.db.BeginTransaction rs = conect.db.ExecQuery("Select total(Valor) as TotalTitulos, " & _...

SubName: N/A its simply a concept/idea that would appear very easy to implement, with possibly great benefits for performance. But totally untested, only created it and put a file in it, and it acted just like normal storage. Description: Historically, I have seen my IO access on storage around...

https://www.b4x.com/android/forum/threads/error-with-customlistview.97829/ As per discussion in this forum I got that TransactionTooLargeException error is in sql query I change query and add limit in that, its working fine now. But I have to add all records in clv, What should I do?

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 are A, B and AB_Map where AB_Map table is the link table between A and B. Considering table B immutable (records inside table B never change so table B...

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