Problem creating a paradox table with ODBC
Posted on 2003-03-17
I've some troubles trying to create a paradox table with vb using the 'Microsoft Paradox Driver'.
If I use the following query :
"CREATE TABLE ORDER (N_ORDER integer, N_SIRET CHAR(20), ETS_N_SIRET CHAR(20))"
the table is created without problem.
But if I try to create the same table with a primary key constraint :
"CREATE TABLE ORDER (N_ORDER integer PRIMARY KEY, N_SIRET CHAR(20), ETS_N_SIRET CHAR(20))"
I've the error:
[Microsoft][ODBC Paradox Driver] and a message saying that the db engine cannot find 'Index_935AEF87_9C85_4EE3'
(I've tried to change the query by using "PRIMARY KEY (N_ORDER)" at the end or with an "ALTER TABLE", the problem is the same)
I suppose it's a problem with the creation of the index but I'm not able to find a solution. Any idea? Thanks for your help and sorry if it's a very basic problem...