Illegal symbol at "3" position.

[william humphrey]

Please try latest beta of vServer


On Sat, Sep 28, 2013 at 3:23 PM, Joseph Morgan <joseph at checkos.com> wrote:

> 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?
>
>     mDatabase.Open( f )
>     mDatabase.DateFormat = EVDateFormat.kYMD
>     mDatabase.DateSep = "-"
>     mDatabase.TimeSep = ":"
>
>
>     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);")
>
> And here's the output:  Illegal symbol at "3" position.
>
>
>
>
> On Sep 28, 2013, at 2:21 PM, Joseph Morgan <joseph at checkos.com> wrote:
>
> 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?
>
>     mDatabase.Open( f )
>     mDatabase.DateFormat = EVDateFormat.kYMD
>     mDatabase.DateSep = "-"
>     mDatabase.TimeSep = ":"
>
>
>     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);")
>
> And here's the output:  Illegal symbol at "3" position.
>
>
> <Screen Shot 2013-09-28 at 2.07.40 PM.png>
>
>
> On Sep 27, 2013, at 8: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
>
>
>
>
> _______________________________________________
> 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/db2ec2a2/attachment.html>