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