Illegal symbol at "3" position.
Joseph Morgan
joseph at checkos.com
Sat Sep 28 15:22:51 CDT 2013
I found the beta and installed
My current server is now: vserver_x64 (Type x64, Server 5.5, Kernel 5.5 b21
Problem solved thank you for suggestions
Now just hoping beta stable enough in all the other places where I use Vserver.
Thanks again!
Joseph
On Sep 28, 2013, at 3:02 PM, Joseph Morgan <joseph at checkos.com> wrote:
> I have tried using "/" as my separator but to no avail.
>
> Also I don't know where to look for the beta where can I find it?
>
> On Sep 28, 2013, at 2:57 PM, Steve Albin <steve at steve-albin.com> wrote:
>
>> I had this same error with version 4.3 recently with a new project and as I recall, the problem was because I was using a "-" instead of a "/" for the date separator. I found that I had to use the same separator as what is set in the Date Time preference for the computer. It did not matter what I set the date separator to in the database.
>>
>> But, I'm still on 4.3 and maybe the problem is different in newer versions.
>>
>> Steve
>>
>> --
>> Steve Albin, Montclair, NJ
>> http://www.steve-albin.com
>> http://www.jazzdiscography.com
>>
>> On Sep 28, 2013, at 3:23 PM, Joseph Morgan 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
>>
>> _______________________________________________
>> 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130928/2e32b38e/attachment.html>
More information about the Valentina
mailing list