Re: [sqlite] Getting rowid for last returned row

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

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

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

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

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

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

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

Re: [sqlite] getting ROWID

c.panel wrote: Hello, I execute a statement and want to have rowid(s) of each row like a : "select rowid,* from mytable;" how can I do this with C API ? thanks ! There's nothing special about selecting ROWIDs in the C API - you just use the query you posted above like you would use any

[sqlite] getting ROWID

Hello, I execute a statement and want to have rowid(s) of each row like a : "select rowid,* from mytable;" how can I do this with C API ? thanks ! -- View this message in context: http://www.nabble.com/getting-ROWID-tp18183418p18183418.html Sent from the SQLite mailing list archive at