Yet again I have a problem ... I'm working with triggers in mijn database, but it seems like my after insert trigger is always fired twice. Right now it's the only trigger on my database and it consists out of two print-messages: print 'begin'; and print 'end';
So there is no other trigger or something to fire the second time and yet still I get 'begin' ' end' 'begin' 'end' so my trigger always fires twice. does anyone have an idea to preventthis from happening??
I tried here on some of my data (changing the table name) and only saw one "begin" and one "end". What version of Pervasive are you using? Also, if it's happening only on this one table, you might check for extra Triggers by issuing a "Select * from x$trigger" statement in the PCC/SQLDM. Check for multiple entries with the same xt$file value.
Certified Pervasive Developer
Certified Pervasive Technician
Custom Btrieve/VB development http://www.mirtheil.com
I do not answer questions by email. Please post on the forum.