[DB-SIG] Foxpro goto command and deleted records

[Ethan Furman]

Carl Karsten wrote:
> On Tue, Jul 17, 2012 at 5:46 PM, Ethan Furman <ethan at stoneleaf.us> 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?
> 
> dBase/FoxPro  had a PURGE command which would actually de-alocate the
> space used for the deleted record.   It also had the concept of a
> record pointer that related to the data on disk.
> 
> Neither is at all part of the SQL spec, and I doubt has anything to do
> with python's dbapi.  So my opinion is this isn't an issue.

Ah, right.  Forgot this list was specifically SQL based.  Sorry for the 
noise.

~Ethan~