Re: using * instead of % in search criteria
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;
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