|Subject||RE: [firebird-support] howto run a program after insert a record|
> I need to fire events to print a label after every insert. Do youthink 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
[mailto:email@example.com] On Behalf Of Codebue Fabio -
Sent: Wednesday, May 07, 2008 3:14 AM
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
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?
_ \ __| _||
__/____|\__ \ _ \ _| _|
_| ____/\___/_| \__|
P-Soft di Codebue Fabio & C. sas
via B.Storti, 19
24060 - Chiuduno - BG
Web : www.p-soft.biz
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.