Re: Trouble with external table qualification using != $NULL$ on enum field

2007-12-03 Thread Albert Bihler
] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, December 03, 2007 1:39 PM To: arslist@ARSLIST.ORG Subject: Re: Trouble with external table qualification using != $NULL$ on enum field .. and 'enumval' != "" Have you tried using $/NULL$ -Original Mess

Re: Trouble with external table qualification using != $NULL$ on enum field

2007-12-03 Thread Opela, Gary L Contr OC-ALC/ITMA
lto:[EMAIL PROTECTED] On Behalf Of J.T. Shyman Sent: Monday, December 03, 2007 12:42 PM To: arslist@ARSLIST.ORG Subject: Re: Trouble with external table qualification using != $NULL$ on enum field Technically speaking "" and NULL are not the same thing. NULL indicates a field isn't set

Re: Trouble with external table qualification using != $NULL$ on enum field

2007-12-03 Thread J.T. Shyman
echnologies Cell: 404-242-5407 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, December 03, 2007 1:39 PM To: arslist@ARSLIST.ORG Subject: Re: Trouble with external table qualification using != $NULL$ on enum field .. and 'enumval&#x

Re: Trouble with external table qualification using != $NULL$ on enum field

2007-12-03 Thread Peter Romain
LIST.ORG > Subject: Trouble with external table qualification using != $NULL$ on enum > field > > 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 qualifi

Re: Trouble with external table qualification using != $NULL$ on enum field

2007-12-03 Thread Joran, Peter P, CTR, OSD-CIO
Have you tried using $/NULL$ -Original Message- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Albert Bihler Sent: Monday, December 03, 2007 12:27 PM To: arslist@ARSLIST.ORG Subject: Trouble with external table qualification using != $NULL$ on

Trouble with external table qualification using != $NULL$ on enum field

2007-12-03 Thread Albert Bihler
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' !