SQL Insert Date

[Johnny Harris]

Update...

I just tried the same query without parameter binding and it worked OK.

So I guess my question now is how to insert into a date field using parameter binding?

Regards,
Johnny Harris

From: Johnny Harris 
Sent: Saturday, October 12, 2013 5:05 PM
To: Valentina Developers 
Subject: SQL Insert Date

Hello everyone,

I’m trying to insert a record and one of the fields is a date field.

I get the following error message:

Date Value “10/12/2013” is invalid. Illegal symbol at “-1” position."

Would anyone happen to have any pointers for inserting dates?
I’m guessing the field is in the wrong format but the format for
the database is set to “MMDDYYYY” and the separator is “/”.

I’m using .net and parameter binding.

Regards,
Johnny Harris


--------------------------------------------------------------------------------
_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20131012/7b13841c/attachment.html>