You can find a used copy of the m$ jet db engine programmers guide for
about $15
http://www.amazon.com/exec/obidos/tg/detail/-/1572313420/qid=1087419761/sr=8-1/ref=sr_8_xs_ap_i1_xgl14/002-2193191-2954402?v=glance&s=books&n=507846
The version I have covers jet 3.5 but the DDL oughtta be much the same.
-mike
ps - if you do find the 'truth', please share :)
Claude Schneegans <[EMAIL PROTECTED]>
06/16/2004 04:44 PM
Please respond to cf-talk
To: CF-Talk <[EMAIL PROTECTED]>
cc:
Subject: Jet 4 ODBC SQL reference?
Hi,
Can some one tell me where I could find an official and complete reference
about the SQL syntax
used in the Access ODBC driver?
For instance, this Microsoft's page:
http://msdn.microsoft.com/library/en-us/dnacc2k/html/acintsql.asp
Claims the the CREATE TABLE ant ALTER TABLE statement accept DEFAULT
values for columns, but the examples given
won't work in a query under CF on an Access 2000 database driver... :-(
So, where is the truth?
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]

