Hi everybody,
If I have a cursor to process which I'm scanning and based on this cursor I need to change (update & insert) several tables (one record per each) is it better (performnce wise) to use
UPDATE where PK = cursor.Field
vs.
if seek(PKField, 'MyTable')
replace in myTable
endif
Assuming all the tables are in buffered 5 mode.
Thanks a lot in advance.
If it's not broken, fix it until it is.
My Blog