[Gambas-bugtracker] Bug #2239: Connection. connection form: SQL requests panel malfunction with date
bugtracker at gambaswiki.org
bugtracker at gambaswiki.org
Fri Jun 11 16:04:09 CEST 2021
http://gambaswiki.org/bugtracker/edit?object=BUG.2239&from=L21haW4-
Comment #3 by Benoît MINISINI:
Here is the output of your program:
2021-06-11 16:03:26.567 gb.db.sqlite3: 0x55c5005b4618: PRAGMA empty_result_callbacks = ON
2021-06-11 16:03:26.567 gb.db.sqlite3: 0x55c5005b4618: PRAGMA full_column_names = ON
The database is open = True
-------------------QUERY (First result)-------------------------------
2021-06-11 16:03:26.567 gb.db.sqlite3: 0x55c5005b4618: SELECT tcust.culas, tcust.curad, tpric.prdes, tcont.costa, tcont.coend FROM tcust, titem, tcont, tpric WHERE tcont.cukey = tcust.cukey AND tcont.itkey = titem.itkey AND tpric.prkey = titem.prkey AND tcont.costa = '2021-07-10 00:00:00' AND tcont.coser IS TRUE;
First result : Lehmann Im Winkel 1 Man bike 10/7/2021 17/7/2021
---------------NEW QUERY (First result)-------------------------------
2021-06-11 16:03:26.568 gb.db.sqlite3: 0x55c5005b4618: SELECT tcust.culas, tcust.curad, tpric.prdes, tcont.costa, tcont.coend FROM tcust, titem, tcont, tpric WHERE tcont.cukey = tcust.cukey AND tcont.itkey = titem.itkey AND tpric.prkey = titem.prkey AND tcont.coend = '2021-06-26 00:00:00' AND tcont.coser IS TRUE;
First result : Brand Heide 34 Lady bike 19/6/2021 26/6/2021
The database is open = False
What's wrong exactly?
Benoît MINISINI changed the state of the bug to: NeedsInfo.
More information about the Bugtracker
mailing list