Re: running sql script via oracle forms 5

There are more than one way to do this, it depens on what it is you want to do.

Please email me with some more info on what you wold like to do. Then I will try to help you.

Sincerly
  Rene
  Chief Consultant

  email : renesn_at_image.dk

"Scott Mattes" <ScottMattes_at_yahoo.com> wrote in message news:8KhD7.15396$EO1.2064321_at_news1.news.adelphia.net...
>
> Short answer: YES
>
> Longer answer: you can easily use form fields as variables in the Where
> clause, just preface the field name with a colon ":". Like i n
>
> select count(*)
> into my_count
> from my_table_name_here
> where field_1 > :tx_number;
>
> It is more involved, but you can also use form fields in the Select and
From
> portions.
>
>
> "Jeanette Weldon" <jeanette.weldon3_at_virgin.net> wrote in message
> news:ZnhD7.22720$GA.3033695_at_news2-win.server.ntlworld.com...
> > Is it possible to run an sql script on an oracle 8i database via an
input
> > parameter from oracle forms 5 ?
> >
> >
>
>
Received on Mon Nov 05 2001 - 16:40:53 CST