Sergey

The PK field is a unique record ID, set by SQL Server itself, and the 10 records I'm editing all exist, it's purely a read from SQL. VFP runs a stored procedure from SQL Server, along the lines of:

begin
set nocount on;
select * from dbo.MyTable where RecordLive = 1
end

My VFP code performs this stored procedure, returns a dataset, loops through each record in the dataset, modifies data in each record, and then once all modifications have been done to each record the VFP code performs a table update. When you return to SQL you see that the modifications that you've done to record 10 are copied across to records 1-9, rather than 1-9 having their own unique updates.