I can't create a Paradox file and insert records using ODBC
I can't create a PARADOX file and insert records.
Using ODBC and MS Visual C++ 6.0 I am trying to create a Paradox (5.0) table
Insert records. I use SQL statements through SQLExecDirect().
The Jet Engine is 4.0 Service Pack6. Borland Database Engine (BDE) is also
In order to insert records into a Paradox table there must be a primary key.
When I try to create the primary key in the CREATE TABLE statement (either
field level or at the table level):
CREATE TABLE MyTableName (RecordID AUTOINC PRIMARY KEY, Field1 CHAR(1), ...);
CREATE TABLE MyTableName (RecordID AUTOINC, Field1 CHAR(1), ... PRIMARY KEY(RecordID);
I am told that the name is not valid, however, instead of displaying my field
it displays a ramdom name that looks like a registry key.
Trying an alternate route, I successfully execute CREATE TABLE but specify
no PRIMARY KEY.
I then use
CREATE UNIQUE INDEX MyTableName ON MyTableName (RecordID)
CREATE UNIQUE INDEX MyTableName ON MyTableName (RecordID) WITH PRIMARY
The first time I execute either of them after opening up the data source
I get the
error message "Could not find field." After that (even after dropping and
the table) I am told that "This operation cannot be performed on a Paradox
a primary key."
I therefore attempted to add a primary key as follows:
ALTER TABLE MyTableName ADD PRIMARY KEY (RecordID)
The first time I exectute this after connecting to the data source I am told
"Index[here follows a long string of seemingly random characters] is not
a valid name."
After that: "This operation cannot be performed on a Paradox table without
a primary key."
Thanks for your help.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL