sqllite

  1. jose sanjuan

    Android Question I have a problem with SQLite that fails when inserting a large number of records into a table. Please Help.

    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.
  2. Abdull Cadre

    Share My Creation LaborLog Lite

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

    Android Question Share the same database (SQLite) for different applications

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

    Android Question Result SET don't see column

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

    B4J Question [Solved] SqlLite , How Select data per month ??

    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 $ ...
  6. behnam_tr

    B4J Question Sqlite Join multiple tables Problem

    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
    • behnam_tr
    • Thread
    • multiple tables sql select join sqllite sqllite select
    • Replies: 3
    • Forum: B4J Questions
  7. G

    Android Question Working with BLOBs and images

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