Illegal symbol at "3" position.

Steve Albin steve at steve-albin.com
Sat Sep 28 14:57:16 CDT 2013 

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

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

More information about the Valentina mailing list