Pervasive.SQL : Error Creating New Table

Finding a good web host for your database sites is a big problem. Check our recommended host for database hosting or the datacenters with the most powerful and reliable dedicated servers suited for large databases.

This databases discussion was started by ohiocowboy 0n 18 July 2008

The following generates an error “The record has a key field containing a duplicate value(Btrieve error 5).
CREATE TABLE Temp1 USING ‘Temp1.DAT’ (PBID IDENTITY, CustID Char(20))

The following do not create an error

CREATE TABLE Temp1 USING ‘Temp1.DAT’ (PBID INTEGER, CustID Char(20))
or
CREATE TABLE Temp1 USING ‘Temp1.DAT’ (PBID CHAR(3), CustID Char(20))

I have tried changing the name to XXXXZZZ and I get the same error-no matter what table name I try to add.

Any reason why is using the data type IDENTITY generating an error?

This is an ongoing problem-every time the ERP software is upgraded I need to add my tables back into the DDFs. This time I can’t.???:

Learn more about Pervasive.SQL databases here. Should you need to go for trustworthy hosting services for all database related sites, we suggest this host for virtual database hosting and this one for dedicated databases hosting