Re: [sqlite] About triggers

2006-08-14 Thread drh
Galanos <[EMAIL PROTECTED]> wrote: > > In a table I have 2 triggers (BEFORE INSERT). How do I know in which order > they are executed (which is first which is second)? > You don't. The order of arbitrary. -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] About triggers

2006-08-14 Thread Galanos
Hello, In a table I have 2 triggers (BEFORE INSERT). How do I know in which order they are executed (which is first which is second)? Thank you Kostas - To unsubscribe, send email to [EMAIL PROTECTED]

Re: [sqlite] About Triggers

2006-08-08 Thread Roberto
On 07/08/06, chetana bhargav <[EMAIL PROTECTED]> wrote: Can you elobarate more on this. ( For me if two threads register for the same trigger condition, with different callback functions, do both the functions get called) The short answer to your question is no. (But I could be wrong) If I

Re: [sqlite] About Triggers

2006-08-07 Thread Christian Smith
chetana bhargav uttered: Hi, I have few questions regarding triggers, * If we want to have trigger for some condition and if multiple applications create a trigger for the same condition providing different C callback functions (which I guess is possible through sqlite3_create_function),

Re: [sqlite] About Triggers

2006-08-07 Thread chetana bhargav
- Last time I tried, the triggers are triggered only for the calling thread which registered the function. Can you elobarate more on this. ( For me if two threads register for the same trigger condition, with different callback functions, do both the functions get called)

[sqlite] About Triggers

2006-08-07 Thread chetana bhargav
Hi, I have few questions regarding triggers, * If we want to have trigger for some condition and if multiple applications create a trigger for the same condition providing different C callback functions (which I guess is possible through sqlite3_create_function), will the trigger be