On 5/19/15, Roman Fleysher <roman.fleysher at einstein.yu.edu> wrote:
> CREATE TRIGGER demographicInsert AFTER INSERT ON subject FOR EACH ROW BEGIN
> INSERT INTO Exam (subjectID, examID, examType) VALUES (NEW.subjectID,
> NEW.subjectID, 'demographicExam');
Your workaround is to change the insert into examID to cast it to type
TEXT. Like this:
.. VALUES(New.subjectID, CAST(New.subjectID AS TEXT), 'demographicExam');
This should be automatic. We are testing the bug fix now. The
work-around is simply to get you going until we can get a patch
release out.
> INSERT INTO wave (subjectID, examType, waveID, examID) VALUES
> (NEW.subjectID, 'demographicExam', 'time1', NEW.subjectID);
> END;
>
--
D. Richard Hipp
drh at sqlite.org
