<html><head><meta http-equiv="content-type" content="text/html; charset=utf-8"></head><body dir="auto"><div>Thank you for the suggestion. I will try and report my results afterwards. </div><div><br></div><div>On Sep 28, 2013, at 2:44 PM, william humphrey <<a href="mailto:bill@bluewatermaritime.com">bill@bluewatermaritime.com</a>> wrote:<br><br></div><blockquote type="cite"><div><div dir="ltr">Please try latest beta of vServer</div><div class="gmail_extra"><br><br><div class="gmail_quote">On Sat, Sep 28, 2013 at 3:23 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"><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" target="_blank">joseph@checkos.com</a>> wrote:</div>
<br><blockquote type="cite"><div style="word-wrap:break-word"><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><div class="h5"><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" target="_blank">joseph@checkos.com</a>> wrote:</div><div><br><blockquote type="cite"><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" target="_blank">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><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" 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>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br><a href="http://www.bluewatermaritime.com/" target="_blank">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" target="_blank">Valentina@lists.macserve.net</a></span><br>
<span><a href="http://lists.macserve.net/mailman/listinfo/valentina" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a></span><br></blockquote></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></blockquote></div><br></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>
</div></blockquote><blockquote type="cite"><div><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></div></blockquote></body></html>