No. can`t increment automatically when import data by XMLPORT

undy0602

Hello all,
My table has one Primary key field that is integer and autoincrement. But it can not increment automatically when I import data by XMLPORT. It appears below error message:
The TestTable already exists. Identification fields and values: No.='0'

Please advise me
Regards,
Undy

EvR

When inserting, you have to assign a value to the identity field. So OnBeforeInsertRecord, just set the value of the PK to '0'. Sounds strange but you have to assign a value.
SQL server will then assign the next available integer.