Am 24.03.2023 um 21:48 schrieb Larry Dalton via lazarus:
No matter how I format the beginning and ending dates, it doesn't work. If I format the dates in quoted strings ('20230101') or any variation, I get the incompatible types errors.
Enclose the date/time by '#', put the date parts in year/month/day order and separate them by slashes:
Query.SQL.Add('SELECT * FROM Events WHERE (StartTime >= #2019/01/15#) AND (StartTime < #2019/01/16#)');
But using query parameters is always the better way. -- _______________________________________________ lazarus mailing list lazarus@lists.lazarus-ide.org https://lists.lazarus-ide.org/listinfo/lazarus
