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