It's okay now. I have fixed it - it was my bug in the end.
I am using SQLOLEDB.
Also found that DATETIME as a parameter to a STORED PROCEDURE appear to have
it's milliseconds rounded.
Myles.
> -----Original Message-----
> From: Neven MacEwan [SMTP:[EMAIL PROTECTED]]
> Sent: Thursday, 6 April 2000 17:12
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: ADO Bugs?
>
> Myles
>
> Which Provider are you using
>
> Regards Neven
> N.K. MacEwan B.E. E&E
> [EMAIL PROTECTED]
>
>
> ----- Original Message -----
> From: Myles Penlington <[EMAIL PROTECTED]>
> To: Multiple recipients of list delphi <[EMAIL PROTECTED]>
> Sent: Thursday, 6 April 2000 14:52
> Subject: [DUG]: ADO Bugs?
>
>
> > Does anybody know of problems with SQL7 fields dealing with BINARY,
> > VARBINARY or TIMESTAMP datatypes.
> > I am trying to pass these to a STORED PROC adn to get data back from an
> ADO
> > STORED PROC, but alas no luck.
> >
> > The data comes back NULL from the select statement. This is in D5.01
> C/S.
> >
> > The SQL works fine from the SQL Query analyser.
> >
> > Thanks.
> >
> > Myles Penlington
> >
> >
> --------------------------------------------------------------------------
> -
> > 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
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
