pascalive wrote:
[pseudocode]
sql=select * from tablename
sqlite_compile
loop
sqlite_step
[function to get _rowid_ from returned row]
endloop
(1) This would slow down queries that do not use the
get_last_rowid() function. It seems like a bad
idea to slow down queries for everybody in order
to provide a function used by very few.
(2) Many queries give results that do not have an
associated rowid for the get_last_rowid() function
to return. What should the get_last_rowid()
function return then? NULL?
(3) This would be a huge change that would require
a lot of code. Isn't it easier just to add
"rowid," in from of the "*" in your query?
How hard is it really to write a routine that
adds the appropriate "rowid," in the middle
of a user-supplied query? 100 lines of code
maybe? Wouldn't that be a better approach?
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
