[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