Article View: borland.public.cppbuilder.database.multi-tier
Article #1149SQL date
From: GIORDANO & C. S.p.A.
Date: Wed, 24 May 2000 00:00
Date: Wed, 24 May 2000 00:00
23 lines
1093 bytes
1093 bytes
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
Technical Details
Message-ID:
<392b899f@dnews>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,3d3e1091d6ce3444,start X-Google-Attributes: gidfcd2b,public From: "GIORDANO & C. S.p.A." <giordano@mtrade.com> Subject: SQL date Date: 2000/05/24 Message-ID: <392b899f@dnews> X-Deja-AN: 626625032 X-Trace: 24 May 2000 00:49:51 -0800, 195.103.91.16 Newsgroups: borland.public.cppbuilder.database.multi-tier X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3