Finally got this SQL thing sorted. On my merry travels trough MSDN deciphering
returned ODBC error codes, I discovered "C to SQL: Timestamp" which describes how
to convert C datatypes into SQL datatypes. Towards the bottom of the list was a
definition of SQL_C_TIMESTAMP structure which was in this format:
"yyyy-mm-dd hh:mm:ss[.f...]"
Lo and behold, using WHERE Date BETWEEN '1999-05-12' AND '1999-06-15' works! This
is an ODBC driver supplied by a third-party so it may crop up elsewhere. As to why
a standard Access query works, I'm guessing, perhaps it tries, tests for error, try
with different format etc. It maybe more intelligent than that, but hey it's
Microsoft :-) Does Bill read this list....
many thanks
Tony Sinclair
Holliday Group Limited
Christchurch
New Zealand
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
