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.???: