Re: using * instead of % in search criteria

From: Marc Ottone <marc.ottone_at_cjb.ville-ge.ch>
Date: 2000/04/28
Message-ID: <3909612b_at_news.unige.ch>#1/1


Thanks Johan!

to be a little bit more generic:

DECLARE

bk_id         BLOCK;
cur_itm       varchar2(80);

cur_block varchar2(80) := :SYSTEM.CURSOR_BLOCK; BEGIN
-- look for all item of current block

   cur_itm := Get_Block_Property( cur_block, FIRST_ITEM );    WHILE ( cur_itm IS NOT NULL ) LOOP
   cur_itm := cur_block||'.'||cur_itm;

  • item to check ? IF NOT(NAME_IN(cur_itm) IS NULL) AND (GET_ITEM_PROPERTY _ (cur_itm,ENABLED)='TRUE') AND (GET_ITEM_PROPERTY _ (cur_itm,ITEM_TYPE)='TEXT ITEM') then COPY(Replace(NAME_IN(cur_itm),'*','%'),cur_itm); END IF; cur_itm := Get_Item_Property( cur_itm, NEXTITEM ); END LOOP; END;
The story is that
1) user put *
2) Forms-PL/SQL change it to %
3) SQL*Net for Rdb change it to * again!
...but it works.

Kind Regards,

Marc

"Johan Wegener" <xjw_at_xdde.xdk> a écrit dans le message news: 8e8uj6$hes$1_at_news101.telia.com...
> Marc Ottone <marc.ottone_at_cjb.ville-ge.ch> skrev i en
> nyhedsmeddelelse:3905d981_at_news.unige.ch...
> Hi,
>
> >We use '*' in search criteria for all our old/various applications and
> >database (Uniface and Oracle Rdb).
> >Is there a simple way to keep the * character (instead of the % symbol)
 in
> >Oracle Forms on Rdb ?
>
> Using Oracle forms you may consider using the PRE-QUERY trigger to
> manipulate the search criteria (the example record) by subsituting an
> entered '*' with a '%'.
>
> Cheers
> Johan
>
>
Received on Fri Apr 28 2000 - 00:00:00 CEST

Original text of this message