Illegal symbol at "3" position.

[Joseph Morgan]

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

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130927/d6b12457/attachment.html>