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
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
: 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
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.
: 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
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
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
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
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
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.
10 matches
Mail list logo