[sqlite] Last_row_id

Hi all; I am using vs15.x Create trigger return_pono after insert on po Begin Select last_insert_rowid(); End Trigger works quite fine in sqlite but fails to return any value to vb.net statement Dim lrow as int64 Lrow = some_cmd.executescalar() Please help Thank you

Re: [sqlite] last_row_id() after insert via trigger

T wrote: Short question: When I explicitly insert a row into a table, I am able to use the last_insert_rowid() function to get the rowid of that inserted row. But how do I get the rowid of a row inserted by a trigger? It seems that last_insert_rowid() doesn't change. Tom, The short

[sqlite] last_row_id() after insert via trigger

Hi all, Short question: When I explicitly insert a row into a table, I am able to use the last_insert_rowid() function to get the rowid of that inserted row. But how do I get the rowid of a row inserted by a trigger? It seems that last_insert_rowid() doesn't change. Longer example: For