Illegal symbol at "3" position.

[william humphrey]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130927/c5dd7dd3/attachment-0001.html>