Wow, that's neat!
Thanks
Bernie Lis
----- Original Message ----- From: "Javier Valencia" <[EMAIL PROTECTED]>
To: "RBG7-L Mailing List" <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 6:53 PM
Subject: [RBG7-L] - RE: Triggers
Sharon:Alternately, I would like to have a button on the form that would print data from the screen right to a report. I don't know how to do this since the data has not been added to table yet.
Here is one little gem I got from Sami that may be of use:
Property rbase_form print 'PRINTER'
This command when called from a form will send an image of the form (not the
screen) to the printer.
You can create a Speed Button with the following code:
Property rbase_form print 'PRINTER' RETURN
When you click on the button, it will send a picture of the form to the
printer. If your form is wide, you may have to set your printer to landscape
as in:
PRNSETUP LANDSCAPE Property rbase_form print 'PRINTER' PRNSETUP PORTRAIT RETURN
Of course you can expand this code to determine the name of your default
printer and the default orientation and after you run the command you can
reset the printer to the original setting. This will allow you to print the
screen before you save it.
Javier,
Javier Valencia, PE
President
Valencia Technology Group, L.L.C.
14315 S. Twilight Ln, Suite #14
Olathe, Kansas 66062-4578
Office (913)829-0888
Fax (913)649-2904
Cell (913)915-3137
================================================
Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material. Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from all system and destroy all copies.
======================================================
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Sharon Lima Sent: Thursday, October 28, 2004 3:20 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Triggers
Hi All,
Great conference with lots of gems! Unrelated to any of those topics, I am working on something most of you learned long ago.
I am trying to use Stored Procedures and Triggers for the first time. I successfully created the Stored Procedure and can run it using the CALL command.
Now, what I want to do is to Trigger the Procedure as an AFTER INSERT. If I understand the documentation correctly, a Trigger runs the Procedure BEFORE the row is inserted, updated or deleted. But, I thought I remembered hearing about AFTER INSERT Triggers at an RBTI Conference in the past.
Also, how do I put the Trigger in place?
What I am trying to do is to enter data for a new row into a form and then as the form is refreshed using an ADD Row button, I want to print a report based on the previously entered row.
Alternately, I would like to have a button on the form that would print data from the screen right to a report. I don't know how to do this since the data has not been added to table yet.
Thanks for any help. Sharon Lima
