>I just want to make sure that my thinking is correct.
>
>I have the following code.
>
>Do While seek(vi_key)
> Replace key with l_key
> tableupdate()
>enddo
>
>My question is: If I move the tableupdate out of the loop, will the seek see the updated records with their new values? I do not want it to, so that is why I am thinking of moving the update out of the loop.
>
>THanks in advance.
>Christine

When you use buffering the code does not get written to disk until you do TableUpdate(). Check out the function's parameters as you can update one record or whole table (ie. many changes, many records).

See help:
TABLEUPDATE( [nRows [, lForce]] [, cTableAlias | nWorkArea] [, cErrorArray] )
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp9/html/3e524579-2348-4587-b7b2-d96ddccdd8f6.asp?frame=true

You can extract (see) buffered record changes with VFP9 SELECT-SQL's [WITH Buffering = lExpr]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp9/html/815f7265-4dfd-40b9-8f19-0673b5a48847.asp?frame=true