Thanks. I’ll learn the parameters.
Sent from my iPhone
> On Mar 24, 2023, at 19:39, Werner Pamler via lazarus
> <lazarus@lists.lazarus-ide.org> wrote:
>
> 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
--
_______________________________________________
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus
