SQL Insert Date

[Joseph Morgan]

It's been my experience that each time you open/connect to vserver, you have to set up date format. I send an SQL execute right after connect that tells the server to use the correct date format. Let me know if you need me to send you the setup string that I use. 

Joseph 

> On Oct 12, 2013, at 5:08 PM, "Johnny Harris" <johnny at southshore.com> wrote:
> 
> 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
> _______________________________________________
> 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/49014bc2/attachment.html>