🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #1149

SQL date

#1149
From: GIORDANO & C. S.p.A.
Date: Wed, 24 May 2000 00:00
23 lines
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-mail

Show 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