Java JDBC.ODBC and DEFAULT ???

K

kahriboo

Hi !!

I want to use a Access (2000) database with java and jdbc.odbc

I try to execute this update :

"CREATE TABLE AAA_DEF (t integer DEFAULT 1)"

But access don't seems to know the 'DEFAULT' keyword...

On microsoft website I found :
"Note : The DEFAULT statement can be executed only through the Jet OLE
DB provider and ADO. It will return an error message if used through
the Access SQL View user interface."

So with java jdbc.odbc how can I create a new table with a DEFAULT
value ??


thanks
kah-riboo
 
Top