Mark,
had similar problem to this when using an ADO interface through an ASP page.
In the end I had to insert the date value as a string
e.g.
INSERT INTO
dailytwr ( Object, MeasDate, Pressure )
VALUES
( 'Cooling Tower', '#07/02/1999#', 473978.321759270330000 )
I can't comment on the '#'s I didn't use them but apparently a few other
guys I used to know had the same problem as they changed the specification
for inserting a date or something in different versions.
I am probably miles off the mark but had no problems after I did this.
Cheers,
Matt.
----- Original Message -----
From: "Mark Derricutt" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, May 25, 2000 3:58 PM
Subject: RE: [DUG]: access
> On Thu, 25 May 2000 [EMAIL PROTECTED] wrote:
>
> > I am using ADO to insert data into a DateTime field in Access at the
> > moment, and I do "01/07/2000" Try that.....From memory, the # is used
> > when doing a select only, and when doing an insert or an update, you
> > use "
>
> Oh the joy of MS standards. Although in this case, this didn't solve the
> problem :( Boss leaves for Japan tomorrow lunchish from what I can see,
> this is the last bug relating to access which will prevent him demo'ing
> the app from his laptop.
>
> Grrrr. :-)
>
> *deep breath*
>
> Mark
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
