First record status inconsistent using SQLite
David Vaughan
dvk at dvkconsult.com.au
Fri May 26 04:53:43 EDT 2006
Using Rev 2.7.1 with AltSqlite/SQLite 3, I found inconsistent
behaviour (as I see it) with the function revdb_isbof alias
RevCurrentRecordIsFirst.
Let us assume you find a record set comprising one record.
-- revdb_isbof will be true (expected)
-- revdb_iseof will be false (not expected)
This is inconsistent.
Let us now assume you find a record set comprising two records
-- revdb_isbof will be true (tick)
-- revdb_iseof will be false (tick)
Now go to the Next (last) record
-- revdb_isbof will be false (tick)
-- revdb_iseof will be false (unexpected)
Now, go back to the first record
-- revdb_isbof will be false (unexpected, and inconsistent with our
starting state)
-- revdb_iseof will be false (tick)
So, the functions purporting to state whether you are at the first or
last record in a cursor will become true only when you attempt to go
_past_ the first or last record, rather than when you are at it.
However, the First Record function inconsistently returns true when
you first obtain the record set but not thereafter for the same
record position.
Is this a Rev bug, a SQLite bug or an AltSQLite bug, or expected
(unexpectedly)?
regards
David
More information about the use-livecode
mailing list