Yep, the problem mutated from a not working query into the discovery how misleading or plain wrong the client side log is.
> On 16. Mar 2018, at 16:32, LJ LongWing <[email protected]> wrote: > > ok...so there isn't actually a problem? > >> On Fri, Mar 16, 2018 at 9:26 AM, Thomas Miskiewicz <[email protected]> >> wrote: >> 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]> >>>> 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] >>>> 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 >> > > -- > ARSList mailing list > [email protected] > https://mailman.rrr.se/cgi/listinfo/arslist
-- ARSList mailing list [email protected] https://mailman.rrr.se/cgi/listinfo/arslist
