> I need to fire events to print a label after every insert. Do you

think it's correct to create a trigger to intercept "after insert" and
using an UDF to call external program?

No. You hinted at a solution yourself when you mentioned events. Have
a trigger signal a Firebird event. Have a software client register for
these events. Whenever it receives an event, select all records that
haven't been printed and print them. Be sure to mark them as printed
and commit after every label successfully prints.

Depending on how you do this with a UDF, you may have code running in
the database's process. At the best, you'd be rewriting existing
functionality.

-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Codebue Fabio -
P-Soft
Sent: Wednesday, May 07, 2008 3:14 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] howto run a program after insert a record

I have a program, not mine and so I don't have source to edit it, that
listen serial port and translate informations from a scales to firebird
database.

I need to fire events to print a label after every insert. Do you think
it's correct to create a trigger to intercept "after insert" and using
an UDF to call external program?


Codebue Fabio
.-----------------------------.
_ \ __| _||
__/____|\__ \ _ \ _| _|
_| ____/\___/_| \__|

P-Soft di Codebue Fabio & C. sas
via B.Storti, 19
24060 - Chiuduno - BG
Italy
Phone: +39.030.839435
Fax: +39.030.5100306
Mobile: +39.348.3515786
.-----------------------------.
Web : www.p-soft.biz
EMail: f.codebue@...

Disclaimer: This message (including attachments) is confidential and may be privileged. If you have received it by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change. RxStrategies, Inc. shall not be liable for the improper or incomplete transmission of the information contained in this communication or for any delay in its receipt or damage to your system. RxStrategies, Inc. does not guarantee that the integrity of this communication has been maintained nor that this communication is free from viruses, interceptions or interference.