Article View: borland.public.cppbuilder.database.ado
Article #3632Re: "1899" display in DBGrid
From: Paul Rodden
Date: Mon, 22 Jul 2002 18:25
Date: Mon, 22 Jul 2002 18:25
7 lines
1243 bytes
1243 bytes
> However, when I want to show the information from this table, for those with > "no date" records, it shows something like "30/12/1899" in the DBGrid. FYI - A zero value for a TDate is "30/12/1899". So if a date field has a zero value in it, Borland interprets it as a date of December 30, 1899 (i.e., if you do an "AsDateTime")
Technical Details
Message-ID:
<3d3c4f26$1_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!sienna.impulse.net!newsfeed.online.be!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!dnewsReferences:
<3d38e063$1_2@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,768350f0065ebcf1 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-07-22 11:35:57 PST From: "Paul Rodden" <nospam_prodden@nospam_jwscorp.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3d38e063$1_2@dnews> Subject: Re: "1899" display in DBGrid Date: Mon, 22 Jul 2002 13:25:26 -0500 Lines: 12 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 66.141.242.129 Message-ID: <3d3c4f26$1_2@dnews> X-Trace: dnews 1027362598 66.141.242.129 (22 Jul 2002 11:29:58 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!sienna.impulse.net!newsfeed.online.be!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!dnews