Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

vb.net NULL

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

Name: Razor2.3
Date: February 4, 2008 at 22:25:42 Pacific

Reply:

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.

0

Batch file that xcopy and...

Batch file trouble

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: By empty, I assume you are refering to a VB5/6 Variant type, which could "hold" an array. If an array (or anything else) was not assigned to a Variant, one could use the IsEmpty() function on the Vari...

Summary: YOu can't use a windows time in a service application. You need to use a System.Timers.Timer. I don't program in vb .net, only c#, but here is how to use it in c#, maybe you can convert it. private Sy...

Summary: C# is being taught in classes already!? I will never get used to the relentless pace of technology. The new .Net languages equivalent for "Declare Function" is DllImport, although the former has been ...