Hello Dave Johns

I thank you to try help me,

in my application before i issue a Update Table..., the recno() from my table is X, and when the Update table is finishied the recno() is Y how i do to stay in the same recno()?

Thanks



>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