Carl Karsten wrote:
On Tue, Jul 17, 2012 at 5:46 PM, Ethan Furman <et...@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~
_______________________________________________
DB-SIG maillist - DB-SIG@python.org
http://mail.python.org/mailman/listinfo/db-sig
