Re: [sqlite] Getting rowid for last returned row

2012-05-11 Thread Scott Ferrett
On 11/05/2012 19:03, Igor Tandetnik wrote: On 5/11/2012 10:36 AM, Scott Ferrett wrote: On 11/05/2012 16:00, Igor Tandetnik wrote: A single row reported by sqlite3_step may contain data derived from the contents of multiple rows of multiple tables. A rowid of which row of which table do you

Re: [sqlite] Getting rowid for last returned row

2012-05-11 Thread Igor Tandetnik
On 5/11/2012 10:36 AM, Scott Ferrett wrote: On 11/05/2012 16:00, Igor Tandetnik wrote: A single row reported by sqlite3_step may contain data derived from the contents of multiple rows of multiple tables. A rowid of which row of which table do you hope to obtain? All of them, including

Re: [sqlite] Getting rowid for last returned row

2012-05-11 Thread Yuriy Kaminskiy
Simon Slavin wrote: > On 11 May 2012, at 3:36pm, Scott Ferrett > wrote: > >> If this is not possible, I can restrict this bit of code to only work on >> UPDATE statements. But that still leaves me with the problem of needing >> the rowid of the row being updated. >

Re: [sqlite] Getting rowid for last returned row

2012-05-11 Thread Simon Slavin
On 11 May 2012, at 3:36pm, Scott Ferrett wrote: > If this is not possible, I can restrict this bit of code to only work on > UPDATE statements. But that still leaves me with the problem of needing the > rowid of the row being updated. The only supplied function

Re: [sqlite] Getting rowid for last returned row

2012-05-11 Thread Scott Ferrett
On 11/05/2012 16:00, Igor Tandetnik wrote: Scott Ferrett wrote: Is there any way that I can get the row id after the call to sqlite3_step A single row reported by sqlite3_step may contain data derived from the contents of multiple rows of multiple tables. A rowid

Re: [sqlite] Getting rowid for last returned row

2012-05-11 Thread Igor Tandetnik
Scott Ferrett wrote: > Is there any way > that I can get the row id after the call to sqlite3_step A single row reported by sqlite3_step may contain data derived from the contents of multiple rows of multiple tables. A rowid of which row of which table do you hope

[sqlite] Getting rowid for last returned row

2012-05-11 Thread Scott Ferrett
I am writing a library that other programmers will use to access SQLite tables. They will send SELECT statements that I have no control over. As such I cannot force the _ROWID_ into the SELECT statement. I need the rowid to use with the sqlite3_blob_open function. Is there any way that I