URGENT - "please help" Setting date format in Livecode

[william humphrey]

So it appears what I need is a way to completely "uninstall" vServer so I
can do a clean install. Just trashing the VServer_64 folder in the library
does not do the trick.




On Fri, Sep 6, 2013 at 12:25 PM, william humphrey <
bill at bluewatermaritime.com> wrote:

> Well we are getting closer. I did a clean install on another computer with
> everything new and it works fine. So something is wrong with the install,
> either the vServer install or the V4REV install that I did on this machine.
>  Very odd that some problem with install would affect the date settings and
> nothing else.  I'm going to delete the V4REV install on this machine and do
> it again and see if that fixes it as I suspect that is the culprit.
>
> Thank you for trying to help. I don't think it will be possible to find
> the route cause of the problem...
>
>
> On Fri, Sep 6, 2013 at 11:04 AM, Ruslan Zasukhin <
> ruslan_zasukhin at valentina-db.com> wrote:
>
>> On 9/6/13 5:06 PM, "william humphrey" <bill at bluewatermaritime.com> wrote:
>>
>> Hi William,
>>
>> Do you see that UID is different?
>>
>>
>> > Now I notice in vStudio that the date format is set correctly but I
>> still get
>> > the error:
>> >
>> > Fri Sep  6 2013 10:01:22.124716 (TID 4345270272): (UID 24) ERROR
>> 0x70503:
>> > Table "vs_database_queries" not found.
>> > Fri Sep  6 2013 10:01:22.134534 (TID 4344733696): (UID 24) ERROR
>> 0x70503:
>> > Table "vs_database_queries" not found.
>>
>> This is from Vstudio -- ignore
>>
>> > Fri Sep  6 2013 10:01:45.645217 (TID 4345270272): (UID 20) ERROR
>> 0x62501: Date
>> > value "2013-09-06" is invalid. Illegal symbol at "3" position.
>>
>> This is from your app I think
>>
>>
>> Okay I think I know where is problem.
>>
>> Working with VSERVer, your APP in your code must each time always inform
>> which DatTimeFormat it wants.
>>
>> This is NOT saved to disk into db,
>> Because each client around VSERVER can have own format.
>>
>>
>> So I think Vstudio use and show on format,
>> But your app use another ...
>>
>>
>>
>> ======================================
>> Later added:
>>    Hmm, I see your prev letter with V4REV log ...
>>
>>
>> > On Fri, Sep 6, 2013 at 9:28 AM, william humphrey <
>> bill at bluewatermaritime.com>
>> > wrote:
>> > LOG SAYS THIS:
>> >
>> > VDatabase_Open...
>> > PARAM: dbRef = "275884240"
>> > PARAM: inStrPath = "b_l_database.vdb"
>> > return
>> > VDatabase_DateFormat...
>> > PARAM: dbRef = "275884240"
>> > PARAM: inEnumDateFormat = "kYMD"
>> > return
>>
>> You see this reflected in VSERVER.log ?
>>
>> > VDatabase_DateSep...
>> > PARAM: dbRef = "275884240"
>> > PARAM: inStrValue = "-"
>> > return
>> > VDatabase_Name...
>> > PARAM: dbRef = "275884240"
>> > return res = "b_l_database.vdb"
>> > VDatabase_IsOpen...
>> > PARAM: dbRef = "275884240"
>> > return res = 1
>>
>> And then?
>>
>> Its your app sends this date in SQL?
>>
>>
>> MAY BE your app do CLOSE db after this?
>> And open again?
>>
>>
>> In this case your setting is LOST.
>>
>>
>>
>> --
>> 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-beta mailing list
>> Valentina-beta at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina-beta
>>
>
>
>
> --
> http://www.bluewatermaritime.com
>



-- 
http://www.bluewatermaritime.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-beta/attachments/20130906/8db78365/attachment.html>