-----Original Message----- From: jim [mailto:[EMAIL PROTECTED] Sent: Saturday, December 27, 2003 9:43 PM hi- i am brand new to playing with an sqlite database. i made a trigger in sqlite using TCL scripting language. I used TCL script with triggers to validate data. My problem is I cant figure out where to place RAISE(ROLLBACK,error) for a trigger. Is this more or less the method for validating data in an sqlite database ( some validating script code, sql statement causing trigger to fire, and the actual trigger)? My goal is to validate insert or update data. thank you, marvin ## TCL script with sql statement that causes trigger to fire load "c:/program files/tcl/bin/tclsqlite.dll" sqlite sqlite db "c:/program files/tcl/bin/sqltTest.db" db eval "insert into newTbl values (8, 25) " db close ## ## TCL script proc set age 21 return $age ## ### TCL script Trigger code set myage [ script ] load "c:/program files/tcl/bin/tclsqlite.dll" sqlite sqlite db "c:/program files/tcl/bin/sqltTest.db" db eval "create trigger mytrig after insert on newTbl when ((select count(*) from newTbl where age > $myvar) = 0) begin delete from newTbl where w1 = 8; end " db close ## --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
