Why have I got wrong record from this table?

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

Article #406

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

#406

From: ht
Date: Thu, 02 Nov 2006 07:53

7 lines
1475 bytes

I used ADO to access a Ms Access database.I put a TAdoConnection, a 
TADOTable, a TDataSource and a TDBGrid into the Form,the I have actived the 
dataset,but some datas displayed in the grid is dislike that in the Ms 
Access.especially the  field whose type is DateTime,for example:In ms access
a record's datetime field is 2006-11-20 12:12:31,but in my test application, 
this field has changed to  2006-11-20 12:12:31,so I tested this database in 
vb by ocx,the result is correct.Is the reason in my access table???

Technical Details

Message-ID: <4549a412@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,b24adba74fe8905,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "ht" <ht_ftp@km169.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Why have I got wrong record from this table?
Date: Thu, 2 Nov 2006 15:53:32 +0800
Lines: 9
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
NNTP-Posting-Host: 222.172.245.246
Message-ID: <4549a412@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1162454034 222.172.245.246 (1 Nov 2006 23:53:54 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news4.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail