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