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


Groups > comp.lang.python > #25547

Re: Foxpro goto command and deleted records

Date 2012-07-18 01:01 +0100
From MRAB <python@mrabarnett.plus.com>
Subject Re: Foxpro goto command and deleted records
References <5005EDC0.6050608@stoneleaf.us>
Newsgroups comp.lang.python
Message-ID <mailman.2256.1342569875.4697.python-list@python.org> (permalink)

Show all headers | View raw


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?

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?

If it is merely marked, then I think the best option is 1, or possibly
4 if the file is compacted when closed.

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

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

csiph-web