The ANSI standard is single quotes around strings. It has nothing to do
with BDE.
However, Once again, if you use parameter for dates you will experiance no
further problems ever, except perhaps in the case of a shonky ODBC driver.
There is no case for writing in dates as strings ever.
-----Original Message-----
From: Patrick Dunford <[EMAIL PROTECTED]>
To: Multiple recipients of list database <[EMAIL PROTECTED]>
Date: Friday, 19 May 2000 15:19
Subject: RE: [DUG-DB]: Dates in SQL/Access
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Derricutt, Mark
> Sent: Friday, 19 May 2000 11:48
> To: Multiple recipients of list database
> Subject: RE: [DUG-DB]: Dates in SQL/Access
>
>
> > You might need to use # around the date as well as in:
>
> That worked :-) What on earth is Microsoft thinking with #'s?
As far as I can tell, using quotemarks is a BDE specific way of handling
dates. Not sure what the standard is.
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
