Error running query when field value is NULL

Article View: borland.public.cppbuilder.database.ado

Article #309

Back to borland.public.cppbuilder.database.ado Previous Next

#309

From: Clint Clark
Date: Tue, 18 Jul 2006 19:56

16 lines
1333 bytes

I am having trouble running a query on a table if one of my selected fields 
contains a NULL value.
Example:

    Select * from ItemNonInventory

If any of the fields in that table contain a null value I get an E_FAIL 
error.

Anyone got an idea as to why this happens?

One other question I have is, Is it possible to write a query that looks for 
anyfield that contains null?
This way I can query only records with valid data.

Thanks

Technical Details

Message-ID: <44bd3ccc$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,b8ba995755bd904,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Clint Clark" <cclark@cmms.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Error running query when field value is NULL
Date: Tue, 18 Jul 2006 12:56:44 -0700
Lines: 18
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 69.230.50.165
Message-ID: <44bd3ccc$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1153252556 69.230.50.165 (18 Jul 2006 12:55:56 -0700)
Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail