|
|
|
|
|
|
|
|
|
|
|
| From: Habib HADDAD | E-mail: haddadhabib@hotmail.com | 1 |
Date: Tuesday, August 14, 2001 at 15:46:21
Subject: Null Fields
Comments:
Hi !
I am working on VB project where i link to an Oracle Database . I need to check
if tthe a Field is of Type NULL but i cant find the syntax for it .
I would aprreciate any help
thks :)
| From: Jonathan Grotell | E-mail: grotelljd@bernstein.com | 2 |
Date: Wednesday, September 12, 2001 at 14:29:31
Subject: RE: Null Fields
Comments:
Do you need to check to see if the field VALUE is null or the type? If it's just the value, simply use IsNull() around the value, or to avoid the cost of using an IF statement, you can append an empty string to it and it automatically casts the NULL value to an empty string, i.e. rs.Fields(0).Value & "".
This forum is no longer taking new messages or replies since 01 November 2002. The above material is for reference purposes only.
The new Visual Basic 6.0 forum can be found here.