Access 2003: sql statement question
Dear all,
i'm trying to get the following code to work without success:
String com = "SELECT Instrument.Index FROM Instrument WHERE Instrument.NextCalDate < #5/24/2007#";
s.execute(com);
I get the following error: Error: java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'Instrument.NextCalDate < #5/24/2007#'.
It is because of the <. If i change the < by an = it works fine. The annoying thing is that i've been browsing the forum and some date related questions regarding java/access were explained by giving example code that had the exact same syntax as the code i'm using, so with the use of the < character without using escape characters or whatever. These postings however date from 2004 or something, so what has changed?
I'm using latest JDK, Access 2003 and am connecting via ODBC running on an XP Pro machine.
Help is very much appreciated. Thanks from The Netherlands
Message was edited by:
bassiedude
