I know that there are many times where a rowid could not be returned
(this is why I suggested to return NULL or -1 for example).
A lot of times we don't have access to the sql issued by end users
and a way to retrieve the rowid (if there is one) could simplify a
lot all our code (and I am sure this is true for a lot of other
developers).
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Nov 7, 2006, at 4:14 PM, Igor Tandetnik wrote:
Marco Bambini <[EMAIL PROTECTED]> wrote:
2. maybe with the new sqlite3_compile routine there should also be a
way to retrieve the rowid of the current row (NULL is no valid rowid
is found), a possible API could be sqlite3_rowid to call after each
sqlite3_step only if it returns an SQLITE_ROW is returned.
In general, there is no rowid associated with a row returned by
select. A row may be constructed out of data taken from multiple
rows of multiple tables, or be manufactured without reference to
any table at all. If you want a rowid from a particular table, why
not just retrieve it explicitly, as a column in select statement?
Igor Tandetnik
----------------------------------------------------------------------
-------
To unsubscribe, send email to [EMAIL PROTECTED]
----------------------------------------------------------------------
-------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------