Hi,
I'm trying to create a table in an ACCESS 2000 db using the following create statement.
create table if not exists Title(MuzeID INTEGER,PrelRefNum INTEGER,TitleArticle VARCHAR(3),Title VARCHAR(255),UPC VARCHAR(14),OrigReleaseYear VARCHAR(10),ReleaseFormat VARCHAR(50),ACD VARCHAR(1), primary key(MuzeID,PrelRefNum));
The resulting error is:
java.sql.SQLException: An invalid index expression MuzeID+PrelRefNum, since MS Access index doesn't support complicated expression!
at com.hxtt.global.SQLState.SQLException(Unknown Source)
at com.hxtt.sql.access.g.a(Unknown Source)
at com.hxtt.sql.access.g.a(Unknown Source)
at com.hxtt.sql.access.n.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.executeUpdate(Unknown Source)
at com.hxtt.sql.access.g.a(Unknown Source)
at com.hxtt.sql.access.n.a(Unknown Source)
at com.hxtt.sql.db.a(Unknown Source)
at com.hxtt.sql.bl.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.a(Unknown Source)
at com.hxtt.sql.ag.execute(Unknown Source)
at ...
Thanks for your help.
Nabil.
|
|
Thanks. v2.0.023 supports to use more than one column as primary key in create table sql. Please download the latest JDBC30 package.
|
Main
webmaster@hxtt.com