>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?
Hi, Yoganathan
I'm lurking in this section while waiting for my VFP7, so this hint is probably a no-no, but I believe that you can specify the columns that will take part in the updategram by setting the KeyFieldList (in CursorSetProp) prior to issuing the XMLUpdategram() function. If you omit the IDENTITY column SQL Server will automatically set its value, hopefully.
hth (disregard otherwise)
bye
----------------------------------
António Tavares Lopes