Re: Oracle Forms problem

[Quoted] easiest thing to do is to write some code in the pre-query trigger as such: if instr(:block.item,'#')!=0 then

   :block.item:='%'||:block.item;
end if;

where block.item is the item with the # character.

In article <78728i$8o4$1_at_hfc.hk.super.net>,   "O.K.Man" <okman_at_iname.com> wrote:
> Dear all,
>
> I have table with some key values starting with the '#' sign. When I try to
> query these records from an Oracle Forms, in the Enter-Query mode, I eneterd
> '#%' on the field and then execute query, however, the Oracle Forms return
> the error FRM-40505. By pressing Shift-F1, the system reported the actual
> error is ORA-00911 (invalid character) (If I entered '#00%', the system will
> report error ORA-00920 (invalid relational operator)). In the dialog box
> invoked by pressing Shift-F1, I found that the '=' sign or the 'LIKE'
> keyword was gone from where clause of the SQL statement :
> The where clause are supposed to be :
> col1 LIKE '#%'
> col1 LIKE '#001%'
> but the where clause became :
> col %
> col 001%
> There is no problem for other special characters such as '_at_', '$'
>
> The problem also found in Oracle Forms 5.0.
>
> Please suggest if there is any solution.
>
> Best regards,
>
> O.K.Man
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Jan 21 1999 - 15:20:19 CET