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);

--
_______________________________________________
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus

Reply via email to