Hi all,
I am using database explorer to test an ODBC connection for different
types of SQL and I am unable to get it to accept date literals in the
WHERE clause. I am unsure as to whether I am using the correct
delimiter and if so, does it depend on the SQL definition in the ODBC
driver? e.g. the differences in Microsoft SQL and just about everyone
elses SQL :-)
If I use single quotes around various different types of date literal
e.g. '16/09/99' or '16-09-99' etc I get a Invalid date, time or
timestamp error (BDE Error 13059). If I use double quotes I get Invalid
Column Name (BDE Error 9729). Suggestions anyone
thanks in advance
Tony Sinclair
Holliday Group Limited
Christchurch
New Zealand
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
