Page 1 of 1

DBCREATE

Posted: Fri Jul 10, 2015 3:23 am
by caliendo
Hi,
I run the function dbcreate with default engine FOXCDX. Some files are created with the first byte x31 instead of x30. What does it mean? I use XDBU Clayton Jones for maintenance DBF that fails to open files in that format.
Can you help me, please?
Thanks.

Re: DBCREATE

Posted: Fri Jul 10, 2015 4:46 am
by Wolfgang Ciriack
Wiki is your friend http://www.digitalpreservation.gov/form ... 0325.shtml ;)

0x30 Visual FoxPro
0x31 Visual FoxPro, autoincrement enabled

Re: DBCREATE

Posted: Fri Jul 10, 2015 5:50 am
by rdonnay
I think that the first byte determines whether or not there is a memo file.

Re: DBCREATE

Posted: Fri Jul 10, 2015 6:16 am
by caliendo
Thanks.
It is a XDBU by Clayton Jones problem.
Best regards.
Ettore

Re: DBCREATE

Posted: Fri Jul 10, 2015 7:00 am
by caliendo
Hi Wolfgang,
if I want to create a DBF with no autoincrement enabled, what should I do?
Thanks.
Ettore

Re: DBCREATE

Posted: Fri Jul 10, 2015 9:25 am
by Wolfgang Ciriack
Hi Ettore,
try to create a new database, than append the records from the old one.
When i change from CDX to FOX i used this, and all tables habe 0x30 as first byte.

Re: DBCREATE

Posted: Mon Jul 13, 2015 7:21 am
by caliendo
Thank you Wolfgang,
Your method works fine: if I create a new database using XDBU of Clayton Jones the first byte is x30.
I have to install the new version of an application which changes the structure of many files and I implemented a utility that changes all automatically, but I have the problem that the archives have x31 in the first byte and I can not open them with my utility.
Thank you for your interest.
Best regards. Ettore