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
http://databaseadvisors.com/mailman/listinfo/dba-vb
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
Anthony)
----------------------------------------------------------------------
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
http://databaseadvisors.com/mailman/listinfo/dba-vb
End of dba-VB Digest, Vol 26, Issue 2
*************************************