1. 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...
  2. 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 $ ...
  3. 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
  4. 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...