"1899" display in DBGrid

Article View: borland.public.cppbuilder.database.ado

Article #3620

Back to borland.public.cppbuilder.database.ado Previous Next

#3620

From: Small Potato
Date: Sat, 20 Jul 2002 03:57

17 lines
1586 bytes

Dear all expert,

I am writing an application using C++Builder and MS Access. There is a
database table with field type of "Date/Time", this field act only for Date
ONLY but not Time. When I want to insert a "no date" value to this field, I
insert a "NULL" value to it. And it display "00:00:00" in the MS Access
table which means no date is specified.

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. Here
I want to ask several questions:

1. Is my action correct to input "no date" by set insert a NULL value to it?
2. How can the grid dont display anything for those field that contains
"30/121899"?

Thank you very much.

Technical Details

Message-ID: <3d38e063$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,768350f0065ebcf1,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-19 21:11:17 PST
From: "Small Potato" <sex@usa.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: "1899" display in DBGrid
Date: Sat, 20 Jul 2002 11:57:31 +0800
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 152.101.124.34
Message-ID: <3d38e063$1_2@dnews>
X-Trace: dnews 1027137635 152.101.124.34 (19 Jul 2002 21:00:35 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!fu-berlin.de!news.boerde.de!nntp.cs.uni-magdeburg.de!PeerFeed.KWeb.on.ca!dnews