Hi- i tried a different dll and sql tool. the trigger worked.
i tried a trick and it seems to work. what i did is put the trigger in under the new dll and new sql tool and then copy the updated db (now with a trigger) to my project directory that uses the java wrapper/driver. it is enforcing the trigger now :-) thanks, jim --- Jim McNamara <[EMAIL PROTECTED]> wrote: > Hi- > > This syntax isnt working. > I cant figure out what i am doing wrong. > I created a budget calculator with a sqlite java > wrapper/driver. I am trying to make it a little > easier to use. > > thanks for any tips! > jim > > > CREATE TRIGGER fki_statusDetail_statusMaster_id > BEFORE INSERT ON Status_Detail > FOR EACH ROW BEGIN > SELECT CASE > WHEN ((SELECT ID FROM Status_Master WHERE ID = > NEW.Detail_ID) IS NULL) > THEN RAISE(ABORT, 'insert on detail "table" > violates foreign key ' ) > END; > END; > > > > __________________________________ > Yahoo! Mail - PC Magazine Editors' Choice 2005 > http://mail.yahoo.com > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com