just update won't move the record pointer.
>Hello All!
>
> I'm starting to work with SQL Commands techinic, and i have a doubt about SQL UPDATE TABLE:
>
> If i Issue a Update table ... Where condition by sample
>
> M.Record=Recno("Costumer")
> Update Costumer Set Name="Anderson Reis Girardi" Where Recno("Costumer")=500
> Go M.Record
>
> This command will change the record point of table Costumer, forcing the VFP save the record, though the user don't have issue a =TABLEUPDATE() command, there's any way to avoid this?
>
> How do you do to update your records?
>
>
> Thanks for all to try help me
>
> Tkank specially to Edward PickMan, John Kasion, Jim Booth, Garret FitzGerald, Tony Miller, Craig Berntson, Bob Archer, Cetin Basoz(A good friend) and other who have help-me