Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Delete
Message
 
To
04/08/2008 15:36:22
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Delete
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01336237
Message ID:
01336325
Views:
15
>>>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform