[dba-VB] OT?: How to load null date to SQL2000 from VB

Just a guess, but sql interprets '' goofy.  Try the null word and see if
that works. 

Insert into tablename (field1, fielddate) values ("bob", null)

-----Original Message-----
From: dba-vb-bounces at databaseadvisors.com
[mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Randall R
Anthony
Sent: Friday, June 17, 2005 12:23 PM
To: dba-vb at databaseadvisors.com
Subject: [dba-VB] OT?: How to load null date to SQL2000 from VB

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
http://www.databaseadvisors.com