[Lazarus] Microsft Access Date Select statment

Jean SUZINEAU jean.suzineau at wanadoo.fr
Sat Mar 25 00:14:49 CET 2023

Le 24/03/2023 à 21:48, Larry Dalton via lazarus a écrit :
> Where Trans_date between beginning_date and ending_date;'

May be it would be better  with params ?

"Where Trans_date between :beginning_date and :ending_date;"

and then supposing  your TSQLQuery is declared as sqlq :

   sqlq.Params['beginning_date'].asDate:= EncodeDate( 2023, 01, 01);

More information about the lazarus mailing list