Jerry,
If the record pointer is already on the row, the Xbase REPLACE is going to be a lot faster. If you have to SEEK to the row there's probably not much difference.
>Which is better between #1 and #2 below and is there a big performace difference between the two.
>
>1.) Performing 20 of these commands:
> REPLACE myfield1 WITH var1 IN mytable
> REPLACE myfield2 WITH var2 IN mytable
> REPLACE myfield3 WITH var3 IN mytable
> etc...
>
>VS
>
>2.) Performing 1 of these commands:
>UPDATE mytable SET field1 = var1, field2 = var2, etc...
> WHERE myprimaryfield = somekey