Thanks. I’ll learn the parameters.
Sent from my iPhone
> On Mar 24, 2023, at 19:39, Werner Pamler via lazarus
> 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 st
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/
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['be
On Fri, Mar 24, 2023 at 7:00 AM wrote:
> Am 23.03.2023 um 01:07 schrieb Don Siders via lazarus:
> > My question: Is there a maintainer for IPro that I can offer the
> > patches to? Or, should I post them here or to the issue tracker?
> It's probably me who did most of the changes recently. Althoug
Using Microsoft Access Driver (*.mdb, *.accdb), on Windows 11, with Lazarus
2.22.4.
TSQLQuery
'Select * from bbt1300
Where Trans_date between beginning_date and ending_date;'
where all three are datetimes;
No matter how I format the beginning and ending dates, it doesn't work. If
I format the dat
