Illegal symbol at "3" position.

Joseph Morgan joseph at checkos.com
Sat Sep 28 14:50:15 CDT 2013 

Thank you for the suggestion. I will try and report my results afterwards. 

> On Sep 28, 2013, at 2:44 PM, william humphrey <bill at bluewatermaritime.com> wrote:
> 
> 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
> _______________________________________________
> 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/20130928/a80179a3/attachment-0001.html>

More information about the Valentina mailing list