[sqlite] Triggers in Sqlite using C

2012-06-15 Thread Bageesh.M.Bose
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

Re: [sqlite] Triggers in Sqlite using C

2012-06-15 Thread Christian Smith
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 SQL SELECT command. For example

Re: [sqlite] Triggers in Sqlite using C

2012-06-15 Thread Black, Michael (IS)
: 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 functions, then calling those

Re: [sqlite] Triggers in Sqlite using C

2012-06-15 Thread Jay A. Kreibich
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

2012-06-15 Thread Black, Michael (IS)
: 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: http://sqlite.org/c3ref

Re: [sqlite] Triggers in Sqlite using C

2012-06-15 Thread Igor Tandetnik
Black, Michael (IS) michael.bla...@ngc.com 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

2012-06-15 Thread Igor Tandetnik
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 table - you open a database connection

Re: [sqlite] Triggers in Sqlite using C

2012-06-15 Thread Black, Michael (IS)
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

2012-06-15 Thread Igor Tandetnik
Black, Michael (IS) michael.bla...@ngc.com 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

2012-06-15 Thread Jay A. Kreibich
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 non-fatal.