>best way to locate last record.
>
>i want find last record and want to update
>
>WHERE RECCOUNT()=RECNO()
>
>please tell me if any more best way
>thanks
That will work only if you want to update the Last physical record and ONLY if it isn't deleted and SET DELETE is ON. If SET DELETE is OFF you can update some deleted record.
So I am not sure what you want to update.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.