[Qt-interest] from QT, how to Get sqlite Trigger's Raise Error

Colin S. Miller no-spam-thank-you at csmiller.demon.co.uk
Wed Oct 28 19:52:20 CET 2009


Bala,
> im using QT4.5 and sqlite3
> 
> im using BEFORE INSERT TRIGGER for validation purpose
I'd have said using a CHECK constraint when the table is CREATEd
or ALTERed would be better, assuming your restrictions
can be specified in the CHECK.  CHECK is only enforced in sqlite 3.3.0
and later.

HTH,
Colin S. Miller



More information about the Qt-interest-old mailing list