🚀 go-pugleaf

What is the  problem?
is it syntax, or did it not return the records you wanted?

if it didn't return the records you wanted try
selecting based only on the from_date and from_time
and see if that gives you what you expected.

             select .....
             from ....
             where DATA_INI >= FROM_DATE_TIME->Text

if not modify your where clause to get what you wanted.
Then do the same with the to_date and to_time, and then try combining them.
hope this helps
--Kevin

"GIORDANO & C. S.p.A." <giordano@mtrade.com> wrote in message
news:392b899f@dnews...
> I have an Interbase database with a field
>             DATA_INI date
>
> I need to select the record using 4 TMaskEdit
>             TMaskEdit FROM_DATE
>             TMaskEdit FROM_TIME
>             TMaskEdit TO_DATE
>             TMaskEdit TO_TIME
>
> I want only the record between FROM_DATA and TO_DATA; so that I wrote:
>
>             AnsiString FROM_DATE_TIME = FROM_DATE + FROM_TIME;
>             AnsiString TO_DATE_TIME = TO_DATE + TO_TIME;
>
>             select .....
>             from ....
>             where DATA_INI >= FROM_DATE_TIME->Text
>             and     DATA_INI <= TO_DATE_TIME->Text
>
> This is not ok; what can I do ???
>
> Thank you
> Silvana
>
>