[dba-Tech] On Odious Code

Arthur Fuller artful at rogers.com
Tue Aug 3 15:54:55 CDT 2004


A la Gustav, they didn't ask me either, but I would frankly prefer these
constructs:

If Type(myVar) <> "Date" 'or better, <> vbaDate
If Value(myVar) <> NULL
If Type(myVar) <> "Numeric" 'or better, <> vbaNumeric

And while we're on it, would someone kindly provide examples of the
correct use of IsEmtpy()? This one has always baffled me.

TIA,
A.

-----Original Message-----
From: dba-tech-bounces at databaseadvisors.com
[mailto:dba-tech-bounces at databaseadvisors.com] On Behalf Of
bchacc at san.rr.com
Sent: Tuesday, August 03, 2004 4:31 PM
To: dba-tech at databaseadvisors.com
Subject: RE: [dba-Tech] On Odious Code



I use Not Isull an Not IsDate and Not IsNumeric.  Same thing?

Rocky




More information about the dba-Tech mailing list