Illegal symbol at "3" position.

[Joseph Morgan]

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
> 

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