<div dir="ltr">Now I notice in vStudio that the date format is set correctly but I still get the error:<div><br></div><div><div>Fri Sep 6 2013 10:01:22.124716 (TID 4345270272): (UID 24) ERROR 0x70503: Table "vs_database_queries" not found. </div>
<div>Fri Sep 6 2013 10:01:22.134534 (TID 4344733696): (UID 24) ERROR 0x70503: Table "vs_database_queries" not found. </div><div>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.</div>
</div><div><br></div><div style>This is frustrating</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Fri, Sep 6, 2013 at 9:28 AM, william humphrey <span dir="ltr"><<a href="mailto:bill@bluewatermaritime.com" target="_blank">bill@bluewatermaritime.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">LOG SAYS THIS:<div><br></div><div><div>VDatabase_Open...</div><div><span style="white-space:pre-wrap"> </span>PARAM: dbRef = "275884240"</div>
<div><span style="white-space:pre-wrap"> </span>PARAM: inStrPath = "b_l_database.vdb"</div>
<div>return</div><div></div><div>VDatabase_DateFormat...</div><div><span style="white-space:pre-wrap"> </span>PARAM: dbRef = "275884240"</div><div class="im"><div><span style="white-space:pre-wrap"> </span>PARAM: inEnumDateFormat = "kYMD"</div>
<div>return</div><div></div><div>VDatabase_DateSep...</div></div><div><span style="white-space:pre-wrap"> </span>PARAM: dbRef = "275884240"</div><div class="im"><div><span style="white-space:pre-wrap"> </span>PARAM: inStrValue = "-"</div>
<div>return</div><div></div></div><div>VDatabase_Name...</div><div><span style="white-space:pre-wrap"> </span>PARAM: dbRef = "275884240"</div><div>return res = "b_l_database.vdb"</div><div></div><div>
VDatabase_IsOpen...</div>
<div><span style="white-space:pre-wrap"> </span>PARAM: dbRef = "275884240"</div><div>return res = 1</div></div><div><br></div><div>Problem is still there. </div></div><div class="gmail_extra"><br><br><div class="gmail_quote">
<div><div class="h5">
On Fri, Sep 6, 2013 at 1:46 AM, Ivan Smahin <span dir="ltr"><<a href="mailto:ivan_smahin@paradigmasoft.com" target="_blank">ivan_smahin@paradigmasoft.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div><div class="h5">
<div style="word-wrap:break-word"><br><div><div><div>On Sep 5, 2013, at 11:40 PM, william humphrey <<a href="mailto:bill@bluewatermaritime.com" target="_blank">bill@bluewatermaritime.com</a>> wrote:</div>
<br></div><div><div><blockquote type="cite"><div dir="ltr">To avoid confusion the above is logs. The Livecode commands are:<div><br></div><div><div style="margin:0px;font-size:10px;font-family:Helvetica"> <span style="color:rgb(145,143,0)"><b>get</b></span> VDatabase_DateFormat(gDatabase, <span style="color:rgb(1,24,146)">"kYMD"</span>)</div>
<div style="margin:0px;font-size:10px;font-family:Helvetica"> <span style="color:rgb(145,143,0)"><b>get</b></span> VDatabase_DateSep(gDatabase, <span style="color:rgb(1,24,146)">"-"</span>)</div><div style="margin:0px;font-size:10px;font-family:Helvetica">
<span style="color:rgb(145,143,0)"><b>get</b></span> VDatabase_Open( gDatabase, b_l_database.vdb )</div></div></div></blockquote></div></div></div><div><br></div>Probably this is a reason for error:<div>You call it before database open.</div>
<div><br></div><div>If you check vServer log you should see something like</div><div><div style="margin:0px;font-size:11px;font-family:Menlo;color:rgb(0,132,0)">Database with name "%S" must be opened or created before operation.</div>
<div><span style="border-collapse:separate;border-spacing:0px"><br></span></div><div>But it is changed in 2007 year - not recently.</div><div><div><span style="border-collapse:separate;border-spacing:0px"><br></span></div>
<div>
<span style="border-collapse:separate;border-spacing:0px">-- <br>Best regards,<br>Ivan Smahin<br>Senior Software Engineer<br>Paradigma Software, Inc<br>Valentina - The Ultra-Fast Database<br><a href="http://www.valentina-db.com/" target="_blank">http://www.valentina-db.com</a></span>
</div>
<br></div></div><br></div><br></div></div><div class="im">_______________________________________________<br>
Valentina-beta mailing list<br>
<a href="mailto:Valentina-beta@lists.macserve.net" target="_blank">Valentina-beta@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina-beta" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-beta</a><br>
<br></div></blockquote></div><span class="HOEnZb"><font color="#888888"><br><br clear="all"><div><br></div>-- <br><a href="http://www.bluewatermaritime.com" target="_blank">http://www.bluewatermaritime.com</a>
</font></span></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><a href="http://www.bluewatermaritime.com">http://www.bluewatermaritime.com</a>
</div>