INSERT INTO MasterAccounts (Active,maExpireDate)
VALUES (1, 10/20/1999)
it places invalid date/time to table, but doesnt raises any error.
So I enclosed date value in single quotes:
INSERT INTO MasterAccounts (Active,maExpireDate)
VALUES (1, '10/20/1999')
Now it inserts correct date value, but other query statement starts
to cause error:
SELECT COUNT(*) FROM MasterAccounts a
WHERE a."Active" <> 0
AND (maExpireDate IS NULL OR maExpireDate > '8/3/1999')
In this case ODBC expects date/time value without quotes. Ie INSERT
command requires some syntax for date const-s, but SELECT (or relational
commands) doesnt requires different format for date values.
Is it default behavoir of ODBC/MS Access SQL or I'm making a mistake
somewhere?
PS: I know that I should post such questions to other ODBC related
news/forums, but during last days I've sent several questions to MS's ODBC
newsgroups and did not get any answer.
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart