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>
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
in sql*forms3.0.
Can this be done? huge_field_on_screen will vary of course as to what
into :display1, :display2, :display3
from real_table
where :huge_field_on_screen;
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