LJ, the server side log shows that Mid Tier Client Log is plain wrong!
The server side log shows that the filter I mentioned in my original post DID find what’s expected but a filter a some time later fails instead. Thanks Thomas > On Mar 16, 2018, at 3:19 PM, LJ LongWing <[email protected]> wrote: > > Thomas, > What does the server side sql log show when you try to run the setfield > through a filter? > > On Thu, Mar 15, 2018 at 10:09 AM, Thomas Miskiewicz <[email protected] > <mailto:[email protected]>> wrote: > Hi Listers, > > I got a strange problem: a filter is doing a set fields and finding nothing. > I can find the record using the GUI though. > > In the client side log I see: > > SELECT * FROM (SELECT AR_SQL_Alias0000000000002171 FROM (SELECT > T4474.C536870919, T4474.C1 FROM T4474 WHERE ((T4474.C536870921 = > '000000000000217') AND (T4474.C536870930 = 0) AND (T4474.C536870913 = 'id')) > ORDER BY T4474.C1 ASC NULLS FIRST ) AR_SQL_Alias1 > 0) AND > (AR_RowNumber_Alias1.*, rownum as AR_RowNumber_Alias1) WHERE > ((AR_RowNumber_Alias1 < 104) AND (rownum < 104)) > > I tried: > > SELECT AR_SQL_Alias0000000000002171 FROM (SELECT T4474.C536870919, T4474.C1 > FROM T4474 WHERE ((T4474.C536870921 = '000000000000217') AND > (T4474.C536870930 = 0) AND (T4474.C536870913 = 'id')) ORDER BY T4474.C1 ASC > NULLS FIRST ) > > in the Oracle Developer and it works just fine, i.e. finding what the filter > was supposed to be finding. > > BTW, what is that AR_SQL_Alias thing? Is there any article on that? I was > never run such a query I took from the client side (Mid Tier) log as the > Oracle Developer say “SQL command not properly ended”… > > > Thanks > > Thomas > > > > > > > -- > ARSList mailing list > [email protected] <mailto:[email protected]> > https://mailman.rrr.se/cgi/listinfo/arslist > <https://mailman.rrr.se/cgi/listinfo/arslist> > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
