Re: How to use IBTable'filter property with date datatype ?

Article View: borland.public.interbase.opensource

Article #5493

Back to borland.public.interbase.opensource Previous Next

#5493

From: Xuan Vinh
Date: Tue, 03 Apr 2001 03:59

31 lines
2062 bytes

What program language you use? I write in Delphi environment.

"Dipsy" <-> wrote:
>Sorry about the where. Of course it has to be omitted in the filter property.
>The rest was (as written) just an example.
>
>"xuan vinh" <xuanvinh10@hotmail.com> schrieb im Newsbeitrag news:3ac8360d$1_1@dnews...
>>
>> your code is incorrect, there no "where" keyword permitted(DateField >= "3/1/2001").Other thing, I only want to have '=' not '>='.
>>
>> "Dipsy" <-> wrote:
>> >You will have to write it in the native Interbase format that may differ from
>> >the current system settings.
>> >
>> >For example: where DateField >= "3/1/2001"
>> >
>> >The order of the date components is always the stupid ;-)
>> >US format month/day/year. It would be a good idea to
>> >have a conversion function in IBX for that purpose.
>> >
>> >
>> >"xuan vinh" <xuanvinh10@hotmail.com> schrieb im Newsbeitrag news:3ac7f561$1_1@dnews...
>> >>
>> >> I use IBtable,but do not know how to filter dataset via date datatype field ( Example, I only want to display records that have
>> >date field value 01/01/2001),someone can help me?
>> >
>> >
>>
>
>

Technical Details

Message-ID: <3ac94aa8$1_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

References: <3ac7f561$1_1@dnews> <3ac826ba$1_2@dnews> <3ac8360d$1_1@dnews> <3ac85094_1@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 106772,723daccb62742878
X-Google-Attributes: gid106772,public
X-Google-ArrivalTime: 2001-04-02 21:16:02 PST
From: "Xuan Vinh" <xuanvinh10@hotmail.com>
Sender: "Xuan Vinh" <xuanvinh10@hotmail.com>
Reply-To: "Xuan Vinh" <xuanvinh10@hotmail.com>
Subject: Re: How to use IBTable'filter property with date datatype ?
Newsgroups: borland.public.interbase.opensource
X-User-Info: 202.167.119.145 202.167.119.145    
References: <3ac7f561$1_1@dnews>  <3ac826ba$1_2@dnews>  <3ac8360d$1_1@dnews>  <3ac85094_1@dnews> 
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3ac94aa8$1_1@dnews>
Date: 2 Apr 2001 20:59:36 -0700
X-Trace: dnews 986270376 207.105.83.65 (2 Apr 2001 20:59:36 -0700)
Lines: 32
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone-sjo1.usenetserver.com!news-out-sjo.usenetserver.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Reply to Parent Message