Dynamic "where" clause in query in Sql*forms 3.0

From: Jennifer Farnham <v045100_at_otis1.stortek.com>
Date: Mon, 7 Jun 1993 16:37:09 GMT
Message-ID: <1993Jun7.163709.15957_at_stortek.com>


I want to do this:

    select field1, field2, field3

      into :display1, :display2, :display3
      from real_table
      where :huge_field_on_screen;


in sql*forms3.0.

Can this be done? huge_field_on_screen will vary of course as to what

                     the criteria wil be within this field....

How does one go about doing dynamic sql in sql*forms?

Jennifer Farnham
v045100_at_otis1.stortek.com
StorageTek
Boulder,Colorado

or post to this newsgroup! :-) Received on Mon Jun 07 1993 - 18:37:09 CEST

Original text of this message