<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">I had this same error with version 4.3 recently with a new project and as I recall, the problem was because I was using a "-" instead of a "/" for the date separator. I found that I had to use the same separator as what is set in the Date Time preference for the computer. It did not matter what I set the date separator to in the database. <div><br></div><div>But, I'm still on 4.3 and maybe the problem is different in newer versions.</div><div><br></div><div>Steve</div><div><br><div apple-content-edited="true">
<span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: 'New York'; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">--</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font face="Helvetica" size="3" style="font: normal normal normal 12px/normal Helvetica; ">Steve Albin, Montclair, NJ</font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; "><a href="http://www.steve-albin.com">http://www.steve-albin.com</a></span></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; "><font class="Apple-style-span" face="Helvetica"><a href="http://www.jazzdiscography.com">http://www.jazzdiscography.com</a></font></div></div></span>
</div>
<br><div><div>On Sep 28, 2013, at 3:23 PM, Joseph Morgan wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html charset=us-ascii"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="font-size: 12px; margin: 0px; ">I have more on this problem I am experiencing here's my code: I used Ruslan's suggestion and still same result. So passing an SQL or using "API" way gets same result. Is it possible this is a bug? I looked on mantis and saw that as similar problem was posted there. Any suggestions?</div><div style="font-size: 12px; margin: 0px; min-height: 14px; "><br></div><div style="font-size: 12px; margin: 0px; "> mDatabase.Open( f )</div><div style="font-size: 12px; margin: 0px; "> mDatabase.DateFormat = EVDateFormat.kYMD</div><div style="font-size: 12px; margin: 0px; "> mDatabase.DateSep = "-"</div><div style="font-size: 12px; margin: 0px; "> mDatabase.TimeSep = ":"</div><p style="font-size: 12px; margin: 0px; "> </p><div style="font-size: 12px; margin: 0px; "> dim result as integer = mDatabase.SqlExecute("insert into myTable (MyTimeDate,MyScheduledDateTime,myDoLater,myNumberID,myResultID,myNote,myCID) values ('2013-09-28 06:45:33','2013-09-28 06:45:33',0,0,0,'TestText',1);")</div><div style="font-size: 12px; margin: 0px; "><br></div><div style="font-size: 12px; margin: 0px; ">And here's the output: Illegal symbol at "3" position.</div><div style="font-size: 12px; margin: 0px; "><br></div><div style="font-size: 12px; margin: 0px; "><br></div><div style="font-size: 12px; margin: 0px; "><br></div><div style="font-size: 12px; margin: 0px; "><br></div><div><div>On Sep 28, 2013, at 2:21 PM, Joseph Morgan <<a href="mailto:joseph@checkos.com">joseph@checkos.com</a>> wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="Content-Type" content="text/html charset=us-ascii"><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div style="margin: 0px; font-size: 12px; ">I have more on this problem I am experiencing here's my code: I used Ruslan's suggestion and still same result. So passing an SQL or using "API" way gets same result. Is it possible this is a bug? I looked on mantis and saw that as similar problem was posted there. Any suggestions?</div><div style="margin: 0px; font-size: 12px; min-height: 14px; "><br></div><div style="margin: 0px; font-size: 12px; "> mDatabase.Open( f )</div><div style="margin: 0px; font-size: 12px; "> mDatabase.DateFormat = EVDateFormat.kYMD</div><div style="margin: 0px; font-size: 12px; "> mDatabase.DateSep = "-"</div><div style="margin: 0px; font-size: 12px; "> mDatabase.TimeSep = ":"</div><p style="margin: 0px; font-size: 12px; "> </p><div style="margin: 0px; font-size: 12px; "> dim result as integer = mDatabase.SqlExecute("insert into myTable (MyTimeDate,MyScheduledDateTime,myDoLater,myNumberID,myResultID,myNote,myCID) values ('2013-09-28 06:45:33','2013-09-28 06:45:33',0,0,0,'TestText',1);")</div><div style="margin: 0px; font-size: 12px; "><br></div><div style="margin: 0px; font-size: 12px; ">And here's the output: Illegal symbol at "3" position.</div><div><br></div><div style="margin: 0px; font-size: 12px; "><br></div><div style="margin: 0px; font-size: 12px; "><span><Screen Shot 2013-09-28 at 2.07.40 PM.png></span></div><div style="margin: 0px; font-size: 12px; "><br></div><div style="margin: 0px; font-size: 12px; "><br></div><div style="margin: 0px; font-size: 12px; ">On Sep 27, 2013, at 8:38 PM, Joseph Morgan <<a href="mailto:joseph@checkos.com">joseph@checkos.com</a>> wrote:</div><div><br class="Apple-interchange-newline"><blockquote type="cite"><meta http-equiv="content-type" content="text/html; charset=utf-8"><div dir="auto"><div>Yes, I do. Correct format in vstudio still get the error. What's weird is I can get going again is by turning on or off one of the flags (is nullable) in vstudio but once I quit or close the db in vstudio then the app fails as well as vstudio the next time. Not sure if that makes sense. </div><div><br>On Sep 27, 2013, at 8:22 PM, william humphrey <<a href="mailto:bill@bluewatermaritime.com">bill@bluewatermaritime.com</a>> wrote:<br><br></div><blockquote type="cite"><div dir="ltr">Do you get the same error when using vStudio even though in vStudio you can see that date format is set correctly?</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Sep 27, 2013 at 7:20 PM, Joseph Morgan <span dir="ltr"><<a href="mailto:joseph@checkos.com" target="_blank">joseph@checkos.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">I am running:<div><br></div><div> vserver_x64 (Type x64, Server 5.4.3, Kernel 5.4.3<div>
<br></div><div><br></div><div>I have attempted using sql to set up date-time </div><div><br></div><div>vMyDB.SQLExecute("SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO 'kYMD','-',':'")</div>
<div><br></div><div>Is there any reason why that doesn't work? </div><div><div class="h5"><div> </div><div><br><div><div>On Sep 27, 2013, at 4:00 PM, william humphrey <<a href="mailto:bill@bluewatermaritime.com" target="_blank">bill@bluewatermaritime.com</a>> wrote:</div>
<br><blockquote type="cite"><div dir="ltr">Also what version vServer are you using?</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Sep 27, 2013 at 2:44 PM, Ruslan Zasukhin <span dir="ltr"><<a href="mailto:ruslan_zasukhin@valentina-db.com" target="_blank">ruslan_zasukhin@valentina-db.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">On 9/27/13 8:54 PM, "Joseph Morgan" <<a href="mailto:joseph@checkos.com" target="_blank">joseph@checkos.com</a>> wrote:<br>
<br>
Hi Joseph,<br>
<div><br>
> I am getting this error message when adding a row to a table:<br>
> 12:49:19 Kernel error: 0x62505. Date-time value "2013-09-27 10:47:32" is<br>
> invalid. Illegal symbol at "3" position.<br>
> This happens in my app and in Vstudio<br>
><br>
><br>
> It will work again temporarily if I go in to vstudio and change a flag on the<br>
> column (such as nullable). But once I exit Vstudio, the problem comes back in<br>
> my app that I'm building.<br>
<br>
<br>
</div>This means that DateFormat is different that you try.<br>
<br>
Please note, that about 3-4 years ago, we have made db engine to be more<br>
strict.<br>
<br>
Also was made that DateTime format is NOT saved into db file.<br>
This is because of VSERVER.<br>
<br>
Image that few clients around VSERVER want different formats.<br>
<br>
<br>
So. You need assign<br>
db.open<br>
db.DateTimeFormat = kYMD<br>
<br>
On each open/connect.<br>
<br>
Check this point please.<br>
<span><font color="#888888"><br>
<br>
<br>
--<br>
Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com/" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
</font></span><div><br>
<br>
_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</div></blockquote></div><br><br clear="all"><div><br></div>-- <br><a href="http://www.bluewatermaritime.com/" target="_blank">http://www.bluewatermaritime.com</a>
</div>
_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
</blockquote></div><br></div></div></div></div></div><br>_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><a href="http://www.bluewatermaritime.com/">http://www.bluewatermaritime.com</a>
</div>
</blockquote><blockquote type="cite"><span>_______________________________________________</span><br><span>Valentina mailing list</span><br><span><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a></span><br><span><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a></span><br></blockquote></div>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a><br></blockquote></div><br></div></blockquote></div><br></div>_______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></blockquote></div><br></div></body></html>