"Nadeem Iftikhar"
<[EMAIL PROTECTED]> wrote in
message
news:[EMAIL PROTECTED]
> I am trying to call a C function in a sqlite 2 trigger.
>
> Here is the code
[snipped]
> trigger|example|contacts|0|CREATE TRIGGER example
> AFTER INSERT ON contacts
> BEGIN
> SELECT altcaps('this is a test');
> END
>
> sqlite>insert into contacts values(2);
> SQL error: no such function: altcaps
You seem to think that the code for the function would be embedded into
the database somehow. This is not the case. The database you've created
is only usable by a program that, right after opening a connection,
registers a custom function named altcaps. sqlite command line shell
doesn't do that, naturally.
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
