I am using XMLUpdategrams to Update a SQL Server table from VFP.

The problem I am having is when there is an IDENTITY column in the SQL Server table, and if I want to insert a new row, VFP table will have 0 for the IDENTIY column.

Then XMLUpdateGram also include this clolumn and put the new value as 0. But SQL Server will not allow to insert this record.

Any workarounds?