Re: [sqlite] C Code in a trigger supported in 3.3.x?

Update. I actually have 2 nearly identical triggers as described below. One works, the other produces "shifted" output...it appears that the sqlite3_column_xxx() functions are returning the wrong data when executing in this trigger. Calling the same function from outside the trigger produces

[sqlite] Re: Re: Insert triggers

Dennis Cote wrote: Igor Tandetnik wrote: SQLite does not support cascading triggers. Operations performed by a trigger never cause other triggers to run. This is not true. SQLite supports multiple triggers on the same event (insert, update, or delete) on a single table and it fires all

[sqlite] C Code in a trigger supported in 3.3.x?

This worked in 3.2.8 but not in 3.3.1/2 I delcare a function using sqlite3_create_function()...this takes 1 arg , an integer and calls the usual code to execute a 'select[ based on the integer as a key and does some work based on the result. I declare a temp trigger to call the above

Re: [sqlite] Re: Insert triggers

Igor Tandetnik wrote: nbiggs wrote: Can an insert trigger cause an update trigger to be fired also? My triggers are listed below. I want tgr_on_insert to fire tgr_on_update. SQLite does not support cascading triggers. Operations performed by a trigger never cause other triggers to run.

Re: [sqlite] SQLite on AIX

Your problem is probably in linking. Try compiling without debug ( no -g). That worked for me on AIX 4.2. Bauer, Christoph wrote: Hi, SQLite 3.2.8 and 3.3.2 does'nt compile on an AIX machine. I suspect libtool to call the linker with wrong arguments. /libtool --mode=link cc -g

[sqlite] Insert triggers

Can an insert trigger cause an update trigger to be fired also? My triggers are listed below. I want tgr_on_insert to fire tgr_on_update. --

Re: [sqlite] Version 3.3.2 statistics

Good morning, How did you determine the coverage of code by test cases? p.s. Thanks for the great support for your code! On 1/24/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Interesting statistics on SQLite version 3.3.2: > > 34787 lines of code > 14464 lines of comment > 42%

[sqlite] Version 3.3.2 statistics

Interesting statistics on SQLite version 3.3.2: 34787 lines of code 14464 lines of comment 42% Ratio of comment to code 50405 Additional lines of code used for testing only 6678 Number of base test cases 202906 Number of test cases run on a full regression 1296

Re: [sqlite] SQLite on AIX

"Bauer, Christoph" <[EMAIL PROTECTED]> wrote: > Hi, > > SQLite 3.2.8 and 3.3.2 does'nt compile on an AIX machine. I suspect libtool > to call the linker with wrong arguments. > > Any ideas? > Do make target_source This builds processed C source files in the subdirectory named "tsrc". CD

Re: [sqlite] CODEC

=?iso-8859-2?Q?Jaros=B3aw_Nozderko?= <[EMAIL PROTECTED]> wrote: > Hi Richard, > > is there any public documentation of the last > argument to CODEC (xCodec in Pager) routine available ? > No. That entire interface is subject to change or removal without notice or comment. -- D. Richard Hipp

Re: [sqlite] Slow query after reboot

Geoff Simonds wrote: Thanks to everyone for all the help on this problem. I am going to try creating a new thread to touch the tables at startup. Chris Schirlinger wrote: We have the same issue, to get around it we fire a thread when the program starts, intelligently "touching" every table