Article View: borland.public.cppbuilder.database.ado
Article #3359Re: ACCESS2000 and TIME field
From: Jerry Irons
Date: Wed, 09 Oct 2002 09:39
Date: Wed, 09 Oct 2002 09:39
30 lines
1991 bytes
1991 bytes
Hi Daryl, One way would be to extract the data from the record and display/edit in a TEdit control. Then you can format/change it any way you want, as long as it's converted back when posting the change. -Jerry On Thu, 3 Oct 2002 20:04:20 +1000, "Daryl" <stockd@cqnet.com.au> wrote: >Hi >I am connecting to an ACCESS 2000 database using the BB ADO components, the >problem I am experiencing is that using a Date/Time field within the ACCESS >table to store a TIME (Format set to Short Time) is being displayed in a >TDBEdit control as YYYY HH:MM:SS AM/PM. The year from memory is 1899 (I >think) instead of just the Time ie 13:45 PM. > >There appears no way to alter the format displayed by a TDBEdit control - >books say that it is automatic. You can of course use a FORMAT in the >SELECT clause for the field but then it can not be edited. > >Any help would be good. > >Thanks >Daryl > >
Technical Details
Message-ID:
<cis7qukmfiu1epjorjdpvrstm4r6bf51il@4ax.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news-out.nuthinbutnews.com!propagator2-sterling!news-in-sterling.newsfeed.com!news-in.nuthinbutnews.com!xmission!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3d9c144f$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,6950c56ed81ecee9,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-10-09 03:14:03 PST From: Jerry Irons <JIrons@compuserve.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Re: ACCESS2000 and TIME field Date: Wed, 09 Oct 2002 05:39:43 -0400 Message-ID: <cis7qukmfiu1epjorjdpvrstm4r6bf51il@4ax.com> References: <3d9c144f$1@newsgroups.borland.com> X-Newsreader: Forte Agent 1.91/32.564 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 24.54.9.179 X-Trace: newsgroups.borland.com 1034156247 24.54.9.179 (9 Oct 2002 02:37:27 -0700) Lines: 31 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-04!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!news-out.nuthinbutnews.com!propagator2-sterling!news-in-sterling.newsfeed.com!news-in.nuthinbutnews.com!xmission!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail