Re: Oracle Forms problem

FYI: I don't have a solution for your problem, but of course the behjavior you describe is intended. You may want to consider renaming those columns that begin with #.

The leading #, in Forms enter-query mode, allows such queries as

#BETWEEN a AND b

or

#IN(a, b, c, e)

which are actually extremely useful!

There is also the "Query-Where" dialog which is similar. A variable (e.g. :name) may be used in the query-string, and then a value assigned to that variable when the query is executed -- this variable may also be used in the ORDER BY clause of the query, or to allow OR predicates in the query. So don't start any column names with the colon character either! *grin*

Good Luck.
-Ian

frank_delisle_at_hotmail.com wrote:

> 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 - 17:02:49 CET