Article View: borland.public.cppbuilder.database.ado
Article #310Re: Error running query when field value is NULL
From: Mark Guerrieri
Date: Wed, 19 Jul 2006 15:41
Date: Wed, 19 Jul 2006 15:41
8 lines
1140 bytes
1140 bytes
> 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. select * from sometable s where s.field1 is not null and s.field2 is not null ... Mark
Technical Details
Message-ID:
<44be52bd@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<44bd3ccc$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,b8ba995755bd904 X-Google-Attributes: gid10698b,public X-Google-Language: ENGLISH,ASCII-7-bit From: "Mark Guerrieri" <mguerrieri@no_spam_verizon.net> Newsgroups: borland.public.cppbuilder.database.ado References: <44bd3ccc$1@newsgroups.borland.com> Subject: Re: Error running query when field value is NULL Date: Wed, 19 Jul 2006 11:41:48 -0400 Lines: 10 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; Response NNTP-Posting-Host: 71.245.200.155 Message-ID: <44be52bd@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1153323709 71.245.200.155 (19 Jul 2006 08:41:49 -0700) Path: arc1-ca.pugleaf.net!g2news2.google.com!news3.google.com!news.glorb.com!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail