URGENT - "please help" Setting date format in Livecode

[Ruslan Zasukhin]

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]