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 hope to obtain?
All of them, including possibly multiple rowids for a single table when
the SELECT returning multiple rows from the same table in each step.
So, if I do "select sum(myCol) from myTable;", do you expect a
function that returns a list of rowids from every row in myTable?
SQlite does not maintain this information.
If this is not possible, I can restrict this bit of code to only work on
UPDATE statements.
Would an AFTER UPDATE trigger work for you?
Good idea. I'll play with that.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
