] [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
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
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
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
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
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' !
6 matches
Mail list logo