Re: [sqlite] trigger a non-database event in sqlite

2007-10-24 Thread Dan Kennedy
On Tue, 2007-10-23 at 19:33 -0700, d_maniger06 wrote: > ok..i have this sample code: > > [code] > void printIfInsert() > { > printf( "Insertion was done in t1\n" ); > } > > void createTrigger( sqlite** db, sqlite_vm** pvm ) > { > char* errMsg; > const char** psql = NULL; > const c

Re: [sqlite] trigger a non-database event in sqlite

2007-10-23 Thread John Stanton
d_maniger06 wrote: ok..i have this sample code: [code] void printIfInsert() { printf( "Insertion was done in t1\n" ); } void createTrigger( sqlite** db, sqlite_vm** pvm ) { char* errMsg; const char** psql = NULL; const char* sql = "CREATE TRIGGER onInsertTrig AFTER INSERT on t2

Re: [sqlite] trigger a non-database event in sqlite

2007-10-23 Thread d_maniger06
ok..i have this sample code: [code] void printIfInsert() { printf( "Insertion was done in t1\n" ); } void createTrigger( sqlite** db, sqlite_vm** pvm ) { char* errMsg; const char** psql = NULL; const char* sql = "CREATE TRIGGER onInsertTrig AFTER INSERT on t2 BEGIN printIfInsert;

Re: [sqlite] trigger a non-database event in sqlite

2007-10-23 Thread John Stanton
I that case you need to implenment a custom function and launch it from a trigger. d_maniger06 wrote: im sorry but i havent get your point..im rather new in sqlite and i just need to make a c program, that when i insert on a table in my database, something is written on a file, or even just be

Re: [sqlite] trigger a non-database event in sqlite

2007-10-22 Thread d_maniger06
im sorry but i havent get your point..im rather new in sqlite and i just need to make a c program, that when i insert on a table in my database, something is written on a file, or even just be printed out in the console saying that my table in my database has been updated/inserted.. John Stanton

Re: [sqlite] trigger a non-database event in sqlite

2007-10-22 Thread John Stanton
d_maniger06 wrote: good day!.. i would just like to ask if you can set a trigger to call on a non-database event (e.g. writing to a file) whenever an update/insert has been made to the database..im using c programming language for this..if this is possible, can u give me some links or direct exa

[sqlite] trigger a non-database event in sqlite

2007-10-22 Thread d_maniger06
good day!.. i would just like to ask if you can set a trigger to call on a non-database event (e.g. writing to a file) whenever an update/insert has been made to the database..im using c programming language for this..if this is possible, can u give me some links or direct examples on how to do t