hi,
im using QT4.5 and sqlite3
im using BEFORE INSERT TRIGGER for validation purpose
[is it good idea to put validation on before_insert_trigger???]
im generating err , when the validation fails
like
create TRIGGER MobileValid BEFORE INSERT on PARAM_DETAILS
when new.PARAM_CODE=12
BEGIN
SELECT RAISE(ABORT,'First Digit Should Be 9') where
substr(new.PARAM_VALUE,1,1)<>'9' ;
SELECT RAISE(ABORT,'Length Should Be 10') where
length(new.PARAM_VALUE)<>10 ;
END;
This is working fine.
My question is , how to get this TRIGGER RAISE ERROR in QT application?
IN QT im inserting as
q.exec("insert into PARAM_DETAILS(PARAM_CODE,PARAM_VALUE)
values(12,'9789')");
when i execute this insert code in sqlite3 cmd prompt , i got the error.
but how to capture this err in APPLICAITON?
pls guide me?
bala
--
View this message in context:
http://www.nabble.com/how-to-get-the-Trigger%27s-Raise-err-in-Application-tp26091341p26091341.html
Sent from the SQLite mailing list archive at Nabble.com.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
