True, but the information available is very limited, basically just the NEW
database row and function calls.
CREATE TRIGGER return_pono AFTER INSERT ON po BEGIN
INSERT INTO inserts VALUES
(datetime('now'),'po','return_pono',last_insert_rowid());
END
Unless of course you start writing user defined functions that access the
internal structures of SQLite, which seems quite beyond the current capability
of the OP.
-----Ursprüngliche Nachricht-----
Von: sqlite-users [mailto:[email protected]] Im
Auftrag von Jean-Luc Hainaut
Gesendet: Donnerstag, 20. September 2018 10:40
An: [email protected]
Betreff: Re: [sqlite] [EXTERNAL] Last_row_id
On 17/09/2018 14:05, Hick Gunter wrote:
> A trigger program does not return any result rows.
True. But a "select" query in the body of a trigger can be used to evaluate a
user-defined function (in the "where" clause for instance) in which any action
allowed by your host language can be executed, including writing in a text file
or opening a DB connection.
> -----Ursprüngliche Nachricht-----
> Von: sqlite-users
> [mailto:[email protected]] Im Auftrag von
> Yadwindersingh
> Gesendet: Sonntag, 16. September 2018 03:28
> An: [email protected]
> Betreff: [EXTERNAL] [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
>
>
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
>
> ___________________________________________
> Gunter Hick | Software Engineer | Scientific Games International
> GmbH | Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR:
> 0430013 | (O) +43 1 80100 - 0
>
> May be privileged. May be confidential. Please delete if not the addressee.
> _______________________________________________
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
___________________________________________
Gunter Hick | Software Engineer | Scientific Games International GmbH |
Klitschgasse 2-4, A-1130 Vienna | FN 157284 a, HG Wien, DVR: 0430013 | (O) +43
1 80100 - 0
May be privileged. May be confidential. Please delete if not the addressee.
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
