Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #25554 > unrolled thread

Re: Foxpro goto command and deleted records

Back to article view | Back to comp.lang.python

This discussion starts older than the indexed window; earlier articles aren't shown. The article labeled Started by below is the oldest one visible, not the original post.

Contents

  Re: Foxpro goto command and deleted records MRAB <python@mrabarnett.plus.com> - 2012-07-18 03:57 +0100

#25554 — Re: Foxpro goto command and deleted records

On 18/07/2012 03:19, Ethan Furman wrote:
> MRAB wrote:
>> On 17/07/2012 23:57, Ethan Furman wrote:
>>> In Foxpro if you do a
>>>
>>> GOTO 7
>>>
>>> with deleted off and record 7 is deleted, the record pointer doesn't
>>> move (at least in version 6).
>>>
>>> I don't like that.
>>>
>>> I see four other options:
>>>
>>> 0) don't move the pointer (listed for completeness)
>>> 1) go to that record anyway
>>> 2) go to the next undeleted record
>>> 3) go to the seventh undeleted record (possibly the least practical)
>>> 4) raise an exception
>>>
>>> Any opinions?
>>>
>> What happens when you 'delete' a record? Does it disappear immediately,
>> or is it merely marked for deletion?
>
> Marked for deletion.
>
>> If it is marked for deletion, can it be unmarked? Will a marked record
>> be removed when the file is closed, or does the file need to be
>> explicitly purged/compacted?
>
> Yes, it can be unmarked.  No, the table must be explicitly packed.
>
>> If it is merely marked, then I think the best option is 1, or possibly
>> 4 if the file is compacted when closed.
>
> There is a use_deleted setting that controls whether deleted records are
> accessed or skipped.  Skipping is fine when looping, not so fine when
> going directly to a particular record.
>
If use_deleted is false, does that mean that deleted records are
hidden, or just that when iterating through the records the deleted
ones aren't yielded?

[toc] | [standalone]

Back to top | Article view | comp.lang.python

csiph-web