I'm doing a wrapper of sqlite to freepascal compiler which caches the requested data and uses _ROWID_ to identify the row, so i can properly update the changes made in cached data to the database. The problem with this approach is that the user must explicitely put the _ROWID_ in the field list of the sql statement.
I'd like to know if there's a way to retrieve the _rowid_ of each returned row without asking for it.Something like [pseudocode] sql=select * from tablename sqlite_compile loop sqlite_step [function to get _rowid_ from returned row] endloop i can use both sqlite2 and sqlite3 It's important to me to be clear if there's no way to do that, so i can use another approach Thanks in advance Luiz __________________________________________________________________________ Acabe com aquelas janelinhas que pulam na sua tela. AntiPop-up UOL - É grátis! http://antipopup.uol.com.br/
