[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