🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.opensource
Article #5504

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

#5504
From: Dipsy
Date: Tue, 03 Apr 2001 12:18
45 lines
2670 bytes
Repost: Even after a complete reload I can't see my posts:

Maybe you should describe your problem a little bit more detailed.

But there's still one gues I have.
You are comparing exactly against "01/01/2000" in a date field ?
The date field probably has a time part too. Because of this
you are practically comparing against "01/01/2000 00:00:00".
If you want the whole day, than you have to write:

DateField >= "01/01/2000" and DateField < "01/02/2000"

Write this into the Filter property of IBTable and set Filtered to true.


"Xuan Vinh" <xuanvinh10@hotmail.com> schrieb im Newsbeitrag news:3ac94aa8$1_1@dnews...
>
> 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: <3ac9bf3b_1@dnews>
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.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-03 05:48:03 PST
From: "Dipsy" <->
Newsgroups: borland.public.interbase.opensource
References: <3ac7f561$1_1@dnews>  <3ac826ba$1_2@dnews>  <3ac8360d$1_1@dnews> <3ac85094_1@dnews>
Subject: Repost: How to use IBTable'filter property with date datatype ?
Date: Tue, 3 Apr 2001 14:18:14 +0200
Lines: 48
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 62.153.172.147
Message-ID: <3ac9bf3b_1@dnews>
X-Trace: dnews 986300219 62.153.172.147 (3 Apr 2001 05:16:59 -0700)
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews