Forms 4.0 - how to build WHERE clause dynamically in PL/SQL

I am trying to build an Oracle*Forms applications that will accept selection criteria and logical operators from the user and dynamically build the WHERE clause of a SELECT statement. I am unable to use substitutions
(ie &varname), name_in(variable), or simply variable
in the WHERE clause ('variable' contains the built WHERE clause). Only the VALUE (ie where colname = varname) of the WHERE clause can be stated this way. I would like to *build* this WHERE clause so I do not have to write a hellish IF of CASE statement. Any suggestions??

( BTW I am not able to use the default Forms
  functionality for this application.)

Thanks!
Charles Swift

charless_at_umich.edu Received on Tue Feb 06 1996 - 00:00:00 CET