john landmesser

Seems to be fixed with Revision 8347 I don't know how to close this ticket ...

Hi Jan, See sample app ( that was created for a different bug report!!): https://drive.google.com/file/d/1Bvxr5A3XQkg2V3wdpLP20OY-FsbbOWWM/view?usp=sharing Compile it the sample app with trunk version of ZeosLib. Change Filter to Datum='01.01.2023' or any existing Date That will not work until you change the format to: Datum='2023-01-01' It is a horror: Zcomponent from trunk directory plus zcomponent from within lazarus "Online package Manager" leeds to real mess ... giving up and i keep using the...

Hi Jan, See sample app ( that was created for a different bug report!!): https://drive.google.com/file/d/1Bvxr5A3XQkg2V3wdpLP20OY-FsbbOWWM/view?usp=sharing Compile it the sample app with trunk version of ZeosLib. Set settings to german format of Date like '01.01.2023' Change Filter to Datum='01.01.2023' or any existing Date That will not work until you change the format to: Datum='2023-01-01' It is a horror: Zcomponent from trunk directory plus zcomponent from within lazarus "Online package Manager"...

Hi Jan, See sample app ( that was created for a different bug report!!): https://drive.google.com/file/d/1Bvxr5A3XQkg2V3wdpLP20OY-FsbbOWWM/view?usp=sharing Compile it the sample app with trunk version of ZeosLib. Set settings to german format of Date like '01.01.2023' Change Filter to Datum='01.01.2023' or any existing Date That will not work until you change the format to: Datum='2023-01-01' Ist a horror: Zcomponent from trunk directory plus zcomponent from within lazarus "Online package Manager"...

Zeoslib trunk: Sqlite won't filter a DateTime field anymore since r8324

Hello Jan, that works if i use "calc_Zeit_pro_km>='00:06:19.999' and calc_Zeit_pro_km<'00:06:20.111'" I have to keep that in mind :-( I got a better solution from sqlite forum that works : Calculate a value that can be filtered without any tricks: SELECT TIME(( unixepoch('00:17:35') -- convert your query to seconds - unixepoch ('00:00:00') -- remove basis to give absolute value ) / 7.0, -- perform division, note decimal to force float (unneeded but probably what you are expecting) 'unixepoch') --...

ZQuery on SQlite database: filter on calculated field issue

ZQuery on SQlite database: filter on calculated field issue