🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.delphi.database.dotnet
Article #556

Re: Null database field testing in Delphi 2005

#556
From: Ted Hale
Date: Wed, 05 Jan 2005 16:51
24 lines
1810 bytes
I'm sorry, I realize I left out some detail.  This is Delphi code (Delphi 
Win32) in 2005.  The solution you posted seems to be for the other supported 
languages (eg., VB, JScript).  Also I'm utilizing ADO (dbGo).  Thanks again.

Ted

"Craig van Nieuwkerk" <craigvn@dart.net.au> wrote in message 
news:41db8027@newsgroups.borland.com...
> In .NET you can use DBNull.Value
>
>> In Delphi 5 I would test for a Null value in a database field using:
>>
>> if (dataSet['dataField'] = Null) then
>>     do something;
>>
>> This worked fine.  In Delphi 2005 the compiler reports 'Null' is an
>> undeclared identifier.  Can anyone tell me what replaces this in 2005?
>> Thanks for any help.
>>
>> Ted
>>
>>
>
> 
Technical Details
Message-ID: <41dc1aff$1@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail
References: <41db6026$1@newsgroups.borland.com> <41db8027@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Thread: 1effe6,e4118755d1134eb5
X-Google-Attributes: gid1effe6,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Ted Hale" <thale@comcast.net>
Newsgroups: borland.public.delphi.database.dotnet
References: <41db6026$1@newsgroups.borland.com> <41db8027@newsgroups.borland.com>
Subject: Re: Null database field testing in Delphi 2005
Date: Wed, 5 Jan 2005 11:51:13 -0500
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 68.44.214.153
Message-ID: <41dc1aff$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1104943871 68.44.214.153 (5 Jan 2005 08:51:11 -0800)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!213.200.89.82.MISMATCH!tiscali!newsfeed1.ip.tiscali.net!border2.nntp.ams.giganews.com!border1.nntp.ams.giganews.com!nntp.giganews.com!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail