Re: [sqlite] Re: Q about new SQLite API

2006-11-07 Thread Will Leshner
On 11/7/06, Igor Tandetnik <[EMAIL PROTECTED]> wrote: 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

RE: [sqlite] Re: Q about new SQLite API

2006-11-07 Thread Robert Simpson
> -Original Message- > From: Igor Tandetnik [mailto:[EMAIL PROTECTED] > Sent: Tuesday, November 07, 2006 8:15 AM > To: SQLite > Subject: [sqlite] Re: Q about new SQLite API > > Marco Bambini <[EMAIL PROTECTED]> wrote: > > 2. maybe with the new sqlite3_

Re: [sqlite] Re: Q about new SQLite API

2006-11-07 Thread Marco Bambini
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

[sqlite] Re: Q about new SQLite API

2006-11-07 Thread Igor Tandetnik
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