Why is it not possible to run a query against SQLite that contains functions like row_number() or rank() ? e.g. Dim RS As...
So I'm most likely just being a bit thick today but i can't get my head around how to get this to work; The aim being to have an xml builder...
hi i want to combine two sql query Dim RS As ResultSet=Sql1.ExecQuery2("SELECT * FROM tbl WHERE userid = ? ", Array As Int(uid)) Dim RS As...
I am using SQLITE with B4A. I am using the database in multiple activities. I have created a service to contain my database object. StartAtBoot is...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
