trigger that does'nt register recordset

[wawer]

Hello,
I'm trying to create a trigger that can send mail for each inserting into a table. The trigger works fine, but a problem: for each inserting into the table, it sends mails then any recordset is registered. I have noticed that for data that do not matche conditions inside the trigger, recordsets are registered, and for data that matches the trigger conditions, after sending mail, any is maintained. There is any update or delete SQl instruction in my trigger. Have you an idea for how and why?
Thank you

 

[tlbroadbent]

I'm not following your explanation. Perhaps you could post you TRIGGER code so we could evaluate it. Also explain what you expect to happen when the trigger fires.

Thanks, Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[wawer]

Thank you tlbroadbent for your reply. I have found out a syntax error in the trigger. That explains why it did'nt work.
thank you very much