Re: Help by forms 4.5 problem
Date: Sun, 25 Feb 2001 21:28:24 GMT
Message-ID: <YNem6.26586$5M5.1692462_at_news1.frmt1.sfba.home.com>
try
'where per_beziehungen != ''a'' start with per_nr = 585 connect by prior
per_nr = per_zu_per_nr');
all single quotes
Peter Häusler <luciver_at_teleweb.at> wrote in message
news:4qTl6.84819$GC5.3086851_at_news.chello.at...
> In SqlPlus i write follwing Statement
>
> SELECT ename_1 from bm_personen
> where per_beziehungen != 'a'
> start with per_nr = 585
> connect by prior per_nr = per_zu_per_nr
>
> I get 22 rows
>
> I have a form and wite in the PRE-QUERY Trigger like this
> The Block PERSONEN has as Base Table BM_PERSONEN
>
> set_block_property('PERSONEN',DEFAULT_WHERE,'where per_beziehungen !=
> ''||a||''
> start with per_nr = 585
> connect by prior per_nr = per_zu_per_nr');
>
> I get 1 row and wondering why
> Can anyone help me??
> Peter Häusler
> luciver_at_teleweb.at
>
>
>
Received on Sun Feb 25 2001 - 22:28:24 CET