>>>BROW
>>>GOTO 1
>>>DELETE
>>> PACK
>>>BROW ---- first record still there
>>
>>Moises,
>>GOTO 1 is not the same as GO TOP!!!
>>GOTO 1 is always move the record pointer to FIRST record no matter is it is deleted or not and no matter what is the current SET DELETED status.
>>You should use GO TOP or LOCATE (w/o anything else)
>
>And the definitions of FIRST are different - first record can be anything, depending on currently active index tag; goto 1 goes to the physically first record, where recno()=1. And that may not actually be the top record even if you set order to 0 and Go Top, because you may be in a table buffered alias with added records, where recno()=-1, -2 etc... so go top without order would land you on the latest new record.
>
>So... YMMV (which is nonsense - a Bulgarian, Norwegian, Serb and a Brazilian on the problem, and we're talking MILEAGE? Sheesh...).
:-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.