For this I have no pendant in foex-trial!
I have build a page in my application which works fine until I install FOEX4 HF 3704. It is a leading read-only grid starting empty. This is bound via master-detail-dynamic action to a grid. And this is mirroring its field to a form (see screenshot). The whole page starts with a filterformular, where one can enter some filter-criteria. This fills a table with ID's. The mastergrid filters to this ids.
Because II got the error you can see in the screenshot I set debugmode to LEVEL 6 and can see the causing Statement:
select a.* from (SELECT COUNT(*) OVER () as TOTALROWS,qry.* FROM (SELECT qry.* FROM (SELECT (SELECT to_char(D) FROM (select strabnrtxt as d ,id_strab as r from lb_strab_v) q WHERE (R=qry.ID_STRAB AND ROWNUM=1)) ID_STRAB_FX,ID_STRAB,BRSTTYP,BRSTNR,STATUS,ANLAGEN_TYPTXT,TRENNSTELLE,INBETRIEBNAHME,ID_BRST,ID_KABEL,GEMEINDETXT,STRASSE,SCHALTSTELLE,KABELNR,HAS_DOKS,ID_SST,SEARCH_STRING FROM (SELECT qry.*,NULL AS SEARCH_STRING FROM (with dok as( select count(*) anz_dok,id_obj from ks_dokumente where applikation='SLUX' and objektgruppe='Brst' group by id_obj) SELECT ID_STRAB ,ID_BRST ,ID_KABEL ,ID_SST ,BRSTTYP ,BRSTNR ,STATUS ,Trennstelle ,INBETRIEBNAHME ,gemeindetxt ,strabnrtxt || ' - '|| strname strasse ,sstnr || ' - ' || standort schaltstelle ,kabelnr ,anlagen_typtxt ,case when dok.anz_dok > 0 then 'J' else 'N' end has_doks FROM lb_brstk_v b,dok where b.id_brst=dok.id_obj (+) and id_brst in (select idwert from kx_filter_ids where (abfrage_id=to_number(:P400_ABFRAGE_ID) or :P400_ABFRAGE_ID is null)))qry)qry)qry)qry WHERE 1=1 ORDER BY ID_STRAB_FX ASC NULLS LAST,lower(BRSTNR) ASC NULLS LAST )a where ROWNUM <= :p$_max_rows
I try to find out myself the causing issue, but I failed :-(. I see no fault in my SQL-Statement.
What can I do to find out the fault?
thanks in advance
Eveline
