This is what I wrote in sqlite trigger, can use
CREATE the TRIGGER if not exists asd_log AFTER INSERT
ON purchase
The BEGIN
INSERT INTO infm (name, price_in) VALUES (' exp, 23);
The END;
But, after I get on the transcription to QT sqlite is useless, I open the QT generated with sqlite database, found the trigger didn't create success
This is the trigger statement on QT is no use (in the values of variables into a constant)
Q.p repare (" CREATE the TRIGGER if not exists asd_log AFTER INSERT ON purchase the BEGIN INSERT INTO infm (name, price_in) VALUES (name: price_in:); END." );
Q.b indValue (" name: ", UI - & gt; LineEdit_2 - & gt; The text ());
Q.b indValue (" price_in: "UI - & gt; LineEdit_4 - & gt; The text ());
Just began to learn the small white, is not very good, a bit puzzled