Illegal symbol at "3" position.
Joseph Morgan
joseph at checkos.com
Sat Sep 28 15:02:37 CDT 2013
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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20130928/e4912c1b/attachment-0001.html>
More information about the Valentina
mailing list