Re: [sqlite] Triggers in Sqlite using C

On Fri, Jun 15, 2012 at 12:42:45PM +, Black, Michael (IS) scratched on the wall: > But as somebody pointed out if you muck with database from the shell or > any other program it will die with "function not found" if the trigger > is called. > > Ergo a dummy function to make it happy and

Re: [sqlite] Triggers in Sqlite using C

Black, Michael (IS) wrote: > Looks like that is getting close...but when is this called? BEFORE or AFTER? After, as far as I can tell. -- Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] Triggers in Sqlite using C

Northrop Grumman Information Systems From: sqlite-users-boun...@sqlite.org [sqlite-users-boun...@sqlite.org] on behalf of Igor Tandetnik [itandet...@mvps.org] Sent: Friday, June 15, 2012 8:15 AM To: sqlite-users@sqlite.org Subject: EXT :Re: [sqlite] Triggers in Sqlite

Re: [sqlite] Triggers in Sqlite using C

Bageesh.M.Bose <bageesh...@gmail.com> wrote: > Can anyone tell "How to use Triggers in Sqlite using C" What do you mean by "use triggers", exactly? What are you trying to achieve? If you are asking how to create a trigger, then it's the same way as creating a

Re: [sqlite] Triggers in Sqlite using C

Black, Michael (IS) wrote: > Could the SQLite code add a new dummy function for a callback which we can > then override with our own library? sqlite3_update_hook -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] Triggers in Sqlite using C

se Subject: EXT :Re: [sqlite] Triggers in Sqlite using C On Fri, Jun 15, 2012 at 12:12:22PM +, Black, Michael (IS) scratched on the wall: > Could the SQLite code add a new dummy function for a callback which > we can then override with our own library? Just use an SQL function: h

Re: [sqlite] Triggers in Sqlite using C

On Fri, Jun 15, 2012 at 12:12:22PM +, Black, Michael (IS) scratched on the wall: > Could the SQLite code add a new dummy function for a callback which > we can then override with our own library? Just use an SQL function: http://sqlite.org/c3ref/create_function.html -j -- Jay A.

Re: [sqlite] Triggers in Sqlite using C

se Subject: EXT :Re: [sqlite] Triggers in Sqlite using C On Fri, Jun 15, 2012 at 11:59:33AM +0530, Bageesh.M.Bose wrote: > Can anyone tell "How to use Triggers in Sqlite using C" > Triggers in SQLite can only contain SQL DML statements. But, you can interface with C by defining fun

Re: [sqlite] Triggers in Sqlite using C

On Fri, Jun 15, 2012 at 11:59:33AM +0530, Bageesh.M.Bose wrote: > Can anyone tell "How to use Triggers in Sqlite using C" > Triggers in SQLite can only contain SQL DML statements. But, you can interface with C by defining functions, then calling those functions using SQ

[sqlite] Triggers in Sqlite using C

Can anyone tell "How to use Triggers in Sqlite using C" -- With Regards, *Bageesh.M.Bose* ** ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users