Illegal symbol at "3" position.

[william humphrey]

OK -- then I think you should try updating a test computer to the latest
beta of vServer. I had similar problem and that is how I solved it.


On Fri, Sep 27, 2013 at 9:38 PM, Joseph Morgan <joseph at checkos.com> wrote:

> 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
>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>


-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130928/154074fb/attachment-0001.html>