[Gambas-bugtracker] Bug #2239: Connection. connection form: SQL requests panel malfunction with date

[bugtracker at gambaswiki.org]

http://gambaswiki.org/bugtracker/edit?object=BUG.2239&from=L21haW4-

Comment #18 by Gianluigi GRADASCHI:

this other database was created empty with the sqlite3 command:
$ sqlite3 test.sqlite3
SQLite version 3.31.1 2020-01-27 19:55:54
Enter ".help" for usage hints.
sqlite> .open
sqlite> .save test.sqlite3
sqlite> .exit

It was later opened with a Gambas3 connection and populated with DB code, but this query does not work:

/* Delivery tomorrow */
SELECT tcust.cunam as 'NAME', tcont.costa AS 'START OF RENTAL', tcont.coend AS 'END OF RENTAL'
FROM tcont, tcust
WHERE tcont.cukey=tcust.cukey
AND tcont.costa=date('2021-08-01', '+1 day');

----------------------------------------------------------------------------

Attachment: TestDbCreateWithSqliteFillGambas-0.0.1.tar.gz