Specialty Forums
Security and Virus
General Hardware
CPUs/Overclocking
Networking
Digital Photo/Video
Office Software
PC Gaming
Console Gaming
Programming
Database
Web Development
Digital Home

General Forums
Windows XP
Windows Vista
Windows 95/98
Windows Me
Windows NT
Windows 2000
Win Server 2008
Win Server 2003
Windows 3.1
Linux
PDAs
BeOS
Novell Netware
OpenVMS
Solaris
Disk Op. System
Unix
Mac
OS/2

Drivers
Driver Scan
Driver Forum

Software
Automatic Updates

BIOS Updates

My Computing.Net

Solution Center

Free IT eBook

Howtos

Site Search

Message Find

RSS Feeds

Install Guides

Data Recovery

About

Home
Reply to Message Icon Go to Main Page Icon

vb.net NULL

Original Message
Name: indika_cha
Date: February 4, 2008 at 20:38:07 Pacific
Subject: vb.net NULL
OS: windows xp
CPU/Ram: 3.2 DualCore / 2GB
Comment:
in vb.net, i need to filter the records for value of claim_no="NULL". i use the following:
[OleDbDAChkIntimation.SelectCommand.Parameters("b_claim_no").Value = null ]
but not working. suggest to use "dbnull"

Please help on this.

note pad


Report Offensive Message For Removal


Response Number 1
Name: Razor2.3
Date: February 4, 2008 at 22:25:42 Pacific
Subject: vb.net NULL
Reply: (edit)
This isn't a VB.NET issue, it's a database SQL issue.

You cannot say WHERE someVal = NULL, as NULL is not a "real" value; it's both every value and no value. Instead, you should use WHERE someVal IS NULL.


Report Offensive Follow Up For Removal




Use following form to reply to current message: 

   Name: From My Computing.Net Settings
 E-Mail: From My Computing.Net Settings

Subject: vb.net NULL

Comments:
         

 
  Homepage URL (*): 
Homepage Title (*): 
         Image URL:
 


Data Recovery Software



My PC has been hijacked!

Lexmark 2600 Printer Issues

btk1w1 infected start here post

Unwanted message remians on screen

Slow boot time

The information on Computing.Net is the opinions of its users. Such opinions may not be accurate and they are to be used at your own risk. Computing.Net cannot verify the validity of the statements made on this site. Computing.Net and Computing.Net, LLC hereby disclaim all responsibility and liability for the content of Computing.Net and its accuracy.
PLEASE READ THE FULL DISCLAIMER AND LEGAL TERMS BY CLICKING HERE

All content ©1996-2007 Computing.Net, LLC