Re: SQL Forms #help#

From: Ms. D.H. Harvey <qq45_at_liverpool.ac.uk>
Date: 23 Apr 1999 11:03:03 GMT
Message-ID: <7fpk17$p4l$1_at_news.liv.ac.uk>


analyst_user_at_my-dejanews.com wrote:
: I know its outdated, but I need help with Forms 3.0
: I'm trying something that seems very simple, but I'm having problems.

: From forms I want to call Unix script and pass it a field value from the
  form.
: The field is :report_date.

: Anyone know the syntax?

: -----------== Posted via Deja News, The Discussion Network ==----------
: http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Place what you want in a string and then host the string.

eg
procedure run_host is

      command char(120);
      begin
         command := '$HOME/myscript '
                     || :report_date || ' '
                     || :next_param  || ' '
                       .
                       .
                     || :last_param;
      host (command);
      end;

Hope this helps		Helen
Received on Fri Apr 23 1999 - 13:03:03 CEST

Original text of this message