Hi list, I am currently a bit stunned how ARS / Oracle try to do searches on enum filds that check for != $NULL$
On a tabel field that uses an external qualification as "'enumflag' = 0". I can see in sql log something like "... where (T385.C536870961 = 0)...". If I try this using "'enumflag' != $NULL$" I don't get the result that I would expect. in sql log I see that the whole where-clause of the statement turns to "WHERE (1 = 0)". That obviously doesn't return many matches. I played a bit around wiht "NOT 'enumflag' = 0" but this results also in "WHERE (1 = 0)". If I try the same searching on an ARS integer field everything seems to work fine. Now I could write workflow that always updates the integer field with the value of the enum field and run the searches against the integer field. But this seems quite a lot of overhead and waste of database space for a simple table qualification. Any ideas are greatly appreciated. ARS 7.0.1 Solaris 10 Oracle 10g Kind regards, Albert _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"