Re: Oracle Forms problem

The # operator in default query processing tells the query builder within forms to add everything following the # following the column name. For example, if you type

#between 1 and 10

for column month_no, the query segment will be:

(month_no between 1 and 10)

Therefore, in your case, you want to type:

#like '#001%'

If you want to shield your end users from having to type SQL, then you might want to place the following code segment into a PRE-QUERY trigger:

if substr (:col1, 1, 1) = '#' then

   :col1 := '#like '''||:col1||'%''';
end if;

Joe Zafian
co-author Oracle Unleashed and Oracle 7.3 Developer's Guide Received on Thu Jan 21 1999 - 18:44:54 CET