Do the data files exists? If so, you should add the "IN DICTIONARY" clause to the statement. Also, when the ERP system is updated do all of the DDFs get updated (FILE.DDF, FIELD.DDF, INDEX.DDF as a start)?
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.
I've been trying to isolate the problem. So far I know that if I reinstall the original File and Field DDFs I can add 1 new table with the first field as an Identity data type. When I try to add a second table with a different name and an Identity data type, I get the "btrieve error 5 - trying to add a duplicate record..." I can add an Integer or Char data type. I have tried adding the table using the Pervasive Control Center, VB, VBA - no luck. Any ideas on how to fix this? I have 8 tables with the first field an Identity data type.