SQL*Forms question - Key trigger for spawning report.

From: Steve Frampton <2843600_at_jeff-lab_at_queensu.ca>
Date: Thu, 30 Sep 1993 14:00:18 GMT
Message-ID: <CE66wJ.Ixu_at_knot.ccs.queensu.ca>


Hello!

I have a question...I have written an Oracle Form (Forms 3.0 I think) and I would like the user to have the option to generate a report if he/she hit a certain key (say, the F6 key for example). Is this possible?

It doesn't really matter what the key is, as long as it is (a) easy for a user to remember, and (b) doesn't interfere with normal Forms operations.

I also need to know how to pass the appropriate parameters to the report. For example, I would like to pass the contents of :MASTER.LOCATION_CODE and :MASTER.REPORTING_MONTH (both of which are char fields in the master block of my form). How is this information passed to a RPT file?

Oh...btw I am doing this on a VAX VMS system so the passing parameters business would have to be a DCL-based solution.

Thanks in advance!

--< Voting deadline on soc.couples.intercultural is October 12! >--

Steve Frampton               Home:   <frampton_at_vicuna.ocunix.on.ca>
Kingston, Ontario            School: <2843600_at_jeff-lab.queensu.ca>
Received on Thu Sep 30 1993 - 15:00:18 CET

Original text of this message