sqllite

I have 2 records in the database (see the attached image). I need to show the sum of Payment field and the max of PaidDate field. SELECT sum(PaidAmount) As PaidAmount, Max(PaidDate) As PaidDate FROM tblBilling where WeekEndDate='2024-11-16T00:00:00' The result is shown in the attached...

Hello, I have this problem with sqlite that fails when inserting records into a table. The problem occurs when inserting a large number of records. I attach an application with the problem. Thanks.

LaborLog Lite LaborLog Lite is an Android application developed using the B4XPage framework. This application is designed to facilitate the registration and consultation of working hours and duration, as well as the automatic calculation of the number of hours worked. With a simple and modern...

Good afternoon, I need to share the same database (SQLLIte) on the same device by two different applications. I tried using File.DirRootExternal but it doesn't work... can anyone help me? Thanks in advance

Hi all, I'm developing an app with b4xtable and I wish to import data from a sqllite DB. I have used the Erel's tutorial (B4XTable - Load data from SQL database). Dim rs As ResultSet = sql.ExecQuery("SELECT coalesce(via,"") as via, coalesce(nome_azienda,"") as cliente, coalesce(citta,"") as...

hello my friends I have the following database table and I want to extract the Monthly profit (from the profit column) information with the optimal code. Does anyone have a solution ?? In fact, how many profit did we have per month? like this : Month 1 >> 250,000 $ Month 2 >> 300,000 $ ...

hi guys i have three table i want to get date from three table with one query i confuse and i cant use JOIN keyword and i need help

Could someone please point me in the direction of examples for the following scenario. I need to take pictures with the android camera (using cameraex class I need to save these in a local SQLLIte db in a BLOB field I then need to send these records to a remote MYSQL database using JdbSQL I...