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

In article <1993Jun7.163709.15957_at_stortek.com> v045100_at_otis1.UUCP (Jennifer Farnham) writes:
>
>
>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....

Since I couldn't mail you, I will risk embarassment :-)

I believe you can prepend your query with '#' as the first character. THis will result in your where clause becoming the default where clause for the query.

If you dont want the user to see this you can of course, copy it to anther field. The field MUST be base table field as far as I know.

This is from "advanced" sqlforms book and I have tried to apply its use to your situation.

-- 
Daryl Erwin                                     Net Address: derwin_at_mach2.WLU.CA
Information Systems                             Surface Mail: P4-1, Main Campus 
Wilfrid Laurier University, Waterloo, Ontario 
Bus:(519) 884-1970 x2910                                !edisni deppart m'I pleH