I did see that function and I had already tried that but it just gives me "SQL logic error or missing database". The error code from the step command is 19 (constraint error). I t almost looks like a different error, but if I take out the triggers it works.
Thanks Andy On Wed, Mar 11, 2009 at 2:57 AM, D. Richard Hipp <d...@hwaci.com> wrote: > > On Mar 10, 2009, at 10:07 PM, Andy wrote: > > > > > I am using triggers to handle database integrity as suggested by the > > docs. > > When a violation occurs the 'SELECT RAISE(ROLLBACK, "Blah")' is > > executed. I > > want to get extract the 'Blah' text using the C API but cannot seem > > to work > > out how to do it. I feel I am missing something obvious... can > > anyone please > > help. > > > > http://www.sqlite.org/c3ref/errcode.html > > D. Richard Hipp > d...@hwaci.com > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
