greensparker wrote:
> 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???]
You could have a CHECK constraint in the table definition instead.
> 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?
Check the return value of QSqlQuery::exec, see also QSqlQuery::lastError
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
