[dba-VB] Re: dba-VB Digest, Vol 26, Issue 2

Randall R Anthony RRANTHON at sentara.com
Fri Jun 17 13:52:43 CDT 2005

The passing the Null is where I'm having trouble, Karen.  I tried that
in SQL and it works fine, however trying to pass the Null via a
parameter in a stored procedure, no workee.  I keep getting invalid use
of Null errors or other data type errors.

>>> dba-vb-request at databaseadvisors.com 6/17/2005 1:00:35 PM >>>
Send dba-VB mailing list submissions to
	dba-vb at databaseadvisors.com 

To subscribe or unsubscribe via the World Wide Web, visit
or, via email, send a message with subject or body 'help' to
	dba-vb-request at databaseadvisors.com 

You can reach the person managing the list at
	dba-vb-owner at databaseadvisors.com 

When replying, please edit your Subject line so it is more specific
than "Re: Contents of dba-VB digest..."

Today's Topics:

   1. OT?: How to load null date to SQL2000 from VB (Randall R


Message: 1
Date: Fri, 17 Jun 2005 12:23:16 -0400
From: "Randall R Anthony" <RRANTHON at sentara.com>
Subject: [dba-VB] OT?: How to load null date to SQL2000 from VB
To: <dba-vb at databaseadvisors.com>
Message-ID: <200506171623.j5HGNYR05430 at databaseadvisors.com>
Content-Type: text/plain; charset=US-ASCII

Simply put, if I use a simple insert query:

Insert into tablename (field1, fielddate) values ("bob", '')
My table will show field1 = bob, and fielddate = 1/1/1900.

I've seen all kinds of .Net workarounds, but none work for VB6.0.
Any help is appreciated.  Thanks.


dba-VB mailing list
dba-VB at databaseadvisors.com 

End of dba-VB Digest, Vol 26, Issue 2

More information about the dba-VB mailing list