URGENT - "please help" Setting date format in Livecode

[william humphrey]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina-beta/attachments/20130906/5f5fb42e/attachment.html>