Checking for Nulls in Fields

From: Bernie Hunt <bhunt@xxxxxxxxxxxxx>
Date: Thu, 09 Mar 2006 08:25:14 -0800

Is there a cleaner way to check for nulls in fields? Faster, shorter in
code, or just better way?

If Not IsDBNull(drPatients("Address")) Then tmpStrAddress = CStr(drPatients
("Address"))

Thanks,
Bernie
.

Follow-Ups:
- Re: Checking for Nulls in Fields
  - From: Marina Levit [MVP]

Prev by Date: Re: Datagrid aggregation in each cell
Next by Date: Re: Checking for Nulls in Fields
Previous by thread: Anything special about UNICODE
Next by thread: Re: Checking for Nulls in Fields
Index(es):
- Date
- Thread

Relevant Pages

Re: Maximum List size (item number) limit?
... The following code is shorter and I hope cleaner, ... Kriston-Vizi Janos can fix his problem. ...
(comp.lang.python)
Re: Assigning a vector from a repeated vector
... My naive solution is: ... Is there a better (shorter, cleaner) way of doing this? ... Make use of the 'repmat' function. ...
(comp.soft-sys.matlab)
Re: help with type-punned warning please
... See the new version of my sfreemacro that I just posted. ... It's cleaner ... and shorter (afaik). ...
(comp.lang.c)
A simpler more pythonic approach to adding in
... I need a cleaner (and shorter) way to to look in my home directory or ... cleaner more pythonic approach? ... Prev by Date: ...
(comp.lang.python)