[sqlite] commit and rollback

2007-11-14 Thread d_maniger06
good day!.. i have a list of records that i want to insert in my database..if ever an error occurred ( e.g. insert was not successful ), i want to undo all the previous inserts that i have done..to do this, i have read that i would need to use sqlite3_commit_hook and sqlite3_rollback_hook..i

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

2007-10-23 Thread d_maniger06
please help me on this.. thank you and God bless!.. c",) John Stanton-3 wrote: > > 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 j

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

2007-10-22 Thread d_maniger06
Stanton-3 wrote: > > 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

[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