Keith,

In old versions of FoxPro (or this may go all the way back to FoxBase) the kind of commands you're talking about would cause a problem. VFP handles it fine. You shouldn't have any problem.

>Can I use an optimizable query string to change
>a key field or am I asking for trouble?
>
>I'm looking at trying a statement something like:
>
>

>REPLACE ALL PKey ;
>    WITH XRef.NewPKey ;
>    FOR PKey = XRef.OldPKey
>
>- or possibly -
>
>UPDATE TABLE Cust ;
>    SET PKey = XRef.NewPKey ;
>    WHERE PKey = XRef.OldPKey
>

>
>I know that this kinda thing can hose a SCAN
>loop.
>
>Anyone have any experiences with this?
>
> ...kt