Re: Form 4 question

Out of the box, the only way to do that is to have the user fill in a placeholder variable in Enter Query mode in the column in question, say they type ':V' (colon+"V"). Then, upon execute query the "Query Where" dialog will appear when they can type:

:V IN ('A','C')

Alternately, you could invent a paradigm (like explaining to your users that they can comma-separate the discrete choices they're looking for) then look at what they typed into Enter Query mode in your PRE-QUERY trigger and replace it with a string that begins with the pound-sign and expresses the result in a more SQL-like syntax.

#IN ('A','C')

One easy way to do this would be to REPLACE() all the commas in the string with single-quote, comma, single-quote, then tack on the:

#IN('

to the front of it and

')

to then end with string concatenation.

Hope this gives you some ideas.

--

Steve Muench         Email: smuench_at_oracle.com
Forms Development      CIS: 73404,676
Product Manager
Oracle Corporation