>>All of the records are identical except for a unique PK field.
>>The PK fields do not exist in the SQL Server table.
>>
>>Any ideas?
>
>If the primary key columns do not exist on the server, what did you mark in the update criteria page in the view designer?
>
>You have to tell VFP which columns are the the primary key on the server. When you issue a TABLEUPDATE, VFP creates an UPDATE statement and sends it to the server. If you have the WhereType set to PK and modified, the UPDATE will look something like this:
>
>UDPATE table
>SET changed_column = new_value
>WHERE pk = OLDVAL(pk)
>AND changed_column = OLDVAL(changed_column)
>
>I'm not really sure what VFP would do if you caused it to create an UPDATE that modified multiple rows. Maybe that's the problem you having.
>
>-Mike
To clarify, the PK field is on the server. I meant to say that the data in the PK fields are not on the server yet so it is not a problem with duplicates.
Richard DeZeeuw
DeZeeuw Software Inc.