Illegal symbol at "3" position.

[Joseph Morgan]

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. 

> On Sep 27, 2013, at 8:22 PM, william humphrey <bill at bluewatermaritime.com> wrote:
> 
> Do you get the same error when using vStudio even though in vStudio you can see that date format is set correctly?
> 
> 
>> On Fri, Sep 27, 2013 at 7:20 PM, Joseph Morgan <joseph at checkos.com> wrote:
>> I am running:
>> 
>>  vserver_x64 (Type x64, Server 5.4.3, Kernel 5.4.3
>> 
>> 
>> I have attempted using sql to set up date-time 
>> 
>> vMyDB.SQLExecute("SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO 'kYMD','-',':'")
>> 
>> Is there any reason why that doesn't work? 
>>     
>> 
>>> On Sep 27, 2013, at 4:00 PM, william humphrey <bill at bluewatermaritime.com> wrote:
>>> 
>>> Also what version vServer are you using?
>>> 
>>> 
>>>> On Fri, Sep 27, 2013 at 2:44 PM, Ruslan Zasukhin <ruslan_zasukhin at valentina-db.com> wrote:
>>>> On 9/27/13 8:54 PM, "Joseph Morgan" <joseph at checkos.com> wrote:
>>>> 
>>>> Hi Joseph,
>>>> 
>>>> > I am getting this error message when adding a row to a table:
>>>> >  12:49:19 Kernel error: 0x62505. Date-time value "2013-09-27 10:47:32" is
>>>> > invalid. Illegal symbol at "3" position.
>>>> > This happens in my app and in Vstudio
>>>> >
>>>> >
>>>> > It will work again temporarily if I go in to vstudio and change a flag on the
>>>> > column (such as nullable). But once I exit Vstudio, the problem comes back in
>>>> > my app that I'm building.
>>>> 
>>>> 
>>>> This means that DateFormat is different that you try.
>>>> 
>>>> Please note, that about 3-4 years ago, we have made db engine to be more
>>>> strict.
>>>> 
>>>> Also was made that DateTime format is NOT saved into db file.
>>>> This is because of VSERVER.
>>>> 
>>>> Image that few clients around VSERVER want different formats.
>>>> 
>>>> 
>>>> So. You  need assign
>>>>         db.open
>>>>         db.DateTimeFormat = kYMD
>>>> 
>>>> On each open/connect.
>>>> 
>>>> Check this point please.
>>>> 
>>>> 
>>>> 
>>>> --
>>>> Best regards,
>>>> 
>>>> Ruslan Zasukhin
>>>> VP Engineering and New Technology
>>>> Paradigma Software, Inc
>>>> 
>>>> Valentina - Joining Worlds of Information
>>>> http://www.paradigmasoft.com
>>>> 
>>>> [I feel the need: the need for speed]
>>>> 
>>>> 
>>>> _______________________________________________
>>>> Valentina mailing list
>>>> Valentina at lists.macserve.net
>>>> http://lists.macserve.net/mailman/listinfo/valentina
>>> 
>>> 
>>> 
>>> -- 
>>> http://www.bluewatermaritime.com
>>> _______________________________________________
>>> 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
>> 
> 
> 
> 
> -- 
> http://www.bluewatermaritime.com
> _______________________________________________
> 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/20130927/c9dbaf2a/attachment.html>