When that is done, I have to set the value of the AutoInc fields to the correct maximum value.I'm not even going to pretend to understand this.
Mapping of FoxPro field types in the Xbase++ DDL
Description Field type Length Field type Valtype()
FoxPro Xbase++
Double B 8 F N
Character (text) *) C 1-254 C C
Character (binary) C 1-254 X C
Date D 8 D D
Float F 1-20 N N
Generic G 4 O M
Long signed integer I 4 I N
Logical L 1 L L
Memo (text) *) M 4 or 10 M M
Memo (binary) M 4 or 10 V M
Numeric N 1-20 N N
Time stamp T 8 T C
Currency Y 8 Y N
VarChar *) V 1-254 R C Don't use !
VarBinary Q 1-254 Z C Don't use !
Integer (autoinc) I 4 S N
*) Data is converted according to SET CHARSET
Clipper applicationsYes. But that works indeed the same as I described. Once exported/imported there is NO sync between autoinc fields on other Applications using the same tables.