Bug? ExecQueryAsync with "?"

Erel said:

Can you upload a project with the database that reproduces this issue?

Click to expand...

Erel said:

It has something to do with the way you created the tables.

This code produces the correct results:

B4X:

Utils.sql.ExecNonQuery("CREATE TABLE scheduled2 (id INTEGER, starttime INTEGER)")
For i = 0 To 3
   Utils.sql.ExecNonQuery($"INSERT INTO scheduled2 (id, starttime) VALUES (${1}, ${150000000+i})"$)
Next
Log(Utils.sql.ExecQuerySingleResult2("Select count(*) from scheduled2 where id = " & 1,Null) '4
Log(Utils.sql.ExecQuerySingleResult2("Select count(*) from scheduled2 where id = ?",Array As String(1))) '4

You should make sure that the id column type is INTEGER as you are adding numeric values. It is also possible that you created the database with a SQLite version newer than the OS version.

The queries are passed as-is to the native API.

Click to expand...

--
-- File generated with SQLiteStudio v3.1.0 on lun ott 30 16:44:07 2017
--
-- Text encoding used: System
--
PRAGMA foreign_keys = off;
BEGIN TRANSACTION;

-- Table: notification
CREATE TABLE notification (
    id      INTEGER     PRIMARY KEY AUTOINCREMENT,
    enabled INTEGER (1) DEFAULT (1)
                        NOT NULL,
    idrete  INTEGER     NOT NULL
                        DEFAULT (0),
    tipo    TEXT        NOT NULL
                        DEFAULT "",
    text    TEXT        NOT NULL
                        DEFAULT "",
    ring    TEXT        NOT NULL
                        DEFAULT "",
    custom  TEXT        NOT NULL
                        DEFAULT ""
);


-- Table: scheduled
CREATE TABLE scheduled (
    id     INTEGER    REFERENCES notification (id) ON UPDATE CASCADE
                                                   MATCH [FULL]
                      NOT NULL,
    starttime INTEGER NOT NULL
                      DEFAULT (0),
    idtemp    INTEGER PRIMARY KEY AUTOINCREMENT
);


COMMIT TRANSACTION;
PRAGMA foreign_keys = on;

Erel said:

You can see in the screenshot that the data type is empty. This is why it doesn't treat the string "1" correctly. All bound parameters in Android are set as strings.

Try to create the table on the Android and see whether the type is set properly.

Click to expand...