Re: Launching SQLPLUS from Forms 3.0

Hmm..been a while since I used forms 3.0 . Do the following:

store complete command line in a variable

my_command := 'report.sh SCOTT/TIGER :report_field :inquiry_date';

now use this variable in host call

host('my_command'); (there is also wait/nowait and return code check  option as 2nd parameter to host..check syntax in manual)

If this doesn't work, remove single quote around my_command variable.

good luck

In article <7fkusa$b8k$1_at_nnrp1.dejanews.com>,   analyst_user_at_my-dejanews.com wrote:
> I'm trying to launch SQL*PLUS from Forms 3.0 to view or print a report.
>
> I need the syntax for the HOST command to do this.
> I am running SQL Forms for AIX.
>
> I have this so far.
>
> In a trigger I have the following.
> HOST(report.sh SCOTT TIGER :report_field :inquiry_date);
>
> Please help.
> Thanks.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 21 1999 - 18:56:15 CEST