Help by forms 4.5 problem

[Quoted] 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 Sat Feb 24 2001 - 19:52:48 CET