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