>After updating a large temporary DBF with data, what is the fastest way of updating the corresponding SQL Server table without having to SCAN through the DBF and issuing individual UPDATE commands.
>Note: I have matching Primary keys on the DBF and SQL Server tables.

Russel,
You updated the SPT cursor you got from SQL server, right ? If so set that cursor as updatable and tableupdate. ie:

lnHandle=Sqlstringconnect(;
 'DRIVER=SQL Server;SERVER=servername;Database=Pubs;Trusted_Connection=Yes')
SQLExec(lnHandle,'select * from dbo.authors','v_authors')
CursorSetProp('KeyFieldList','au_id','v_authors')
CursorSetProp('WhereType',1,'v_authors')
CursorSetProp('Tables','authors','v_authors')

CursorSetProp("UpdateNameList", ;
  "au_id    authors.au_id,"+;
  "au_lname authors.au_lname,"+;
  "au_fname authors.au_fname,"+;
  "contract authors.contract",'V_authors')

CursorSetProp('UpdatableFieldList','au_fname,au_lname,contract','v_authors')
CursorSetProp('SendUpdates',.T.,'v_authors')
CursorSetProp('Buffering',5,'v_authors')

* Update the data in browse
Browse title 'Modify data'

* Submit
Tableupdate(2,.T.,'v_authors')
SQLExec(lnHandle,'select * from dbo.authors','afterupdate')
SQLDisconnect(lnHandle)
Select afterupdate
Browse

Cetin