T
Tze-Chiu Lei
Hi ALL!
I'm trying to use the LIMIT clause in an Access 2002 ANSI SQL-92 mode
database, but I'm having 2 problems.
1) My ODBC datasource definition for this Access db does not save the
ExtendedAnsiSQL property after I change it to '1' as indicated in its Online
Help. The change survives a system restart, but doesn't survive a connection
to the db -- whenever I start my Tomcat appserver or my NetBeans IDE to
connect to it.
2) Problem 1 notwithstanding, I also couldn't create a SQL query within
Access using the SQL View in Query Designer either, even though the db's
been set to ANSI SQL-92 mode (which Online Help said would support the LIMIT
clause). Typing "SELECT * FROM table LIMIT 0, 5;" and closing the SQL View,
when I clicked Save I got an error message "Syntax error in FROM clause." as
if LIMIT was never interpreted properly.
Any help/info re. LIMIT usage in Access or ExtendedAnsiSql property in Data
Sources (ODBC) would be much appreciated.
Thank you very much!
Best regards,
Tze-Chiu Lei
GC Webmaster, Centra Administrator
NOL Global Campus
APL, Ltd.
P.S. If anyone knows anything about using MSDE instead of JET, pls. also
email me. I'm wondering if MSDE would be more supportive of SQL via ODBC.
I'm trying to use the LIMIT clause in an Access 2002 ANSI SQL-92 mode
database, but I'm having 2 problems.
1) My ODBC datasource definition for this Access db does not save the
ExtendedAnsiSQL property after I change it to '1' as indicated in its Online
Help. The change survives a system restart, but doesn't survive a connection
to the db -- whenever I start my Tomcat appserver or my NetBeans IDE to
connect to it.
2) Problem 1 notwithstanding, I also couldn't create a SQL query within
Access using the SQL View in Query Designer either, even though the db's
been set to ANSI SQL-92 mode (which Online Help said would support the LIMIT
clause). Typing "SELECT * FROM table LIMIT 0, 5;" and closing the SQL View,
when I clicked Save I got an error message "Syntax error in FROM clause." as
if LIMIT was never interpreted properly.
Any help/info re. LIMIT usage in Access or ExtendedAnsiSql property in Data
Sources (ODBC) would be much appreciated.
Thank you very much!
Best regards,
Tze-Chiu Lei
GC Webmaster, Centra Administrator
NOL Global Campus
APL, Ltd.
P.S. If anyone knows anything about using MSDE instead of JET, pls. also
email me. I'm wondering if MSDE would be more supportive of SQL via ODBC.