<div dir="ltr">Should this property always be set when you open the database, everytime? <div><br></div><div>I haven't seen any examples of anyone doing this in a Runtime Revolution use of Valentina and my present use of it on the Intel platform seems to be fine. But the lack of examples seen is not anything new.</div>
<div><br></div><div>Would the following be corect?<br><div><br></div><div>In Runtime Revolution would you do:</div><div><br></div><div><br></div><div><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><span style=""><i><font class="Apple-style-span" color="#142B86">on</font></i></span><i><font class="Apple-style-span" color="#142B86"> mouseUp pMouseBtnNo</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"> </font></i><span style=""><i><font class="Apple-style-span" color="#142B86">get</font></i></span><i><font class="Apple-style-span" color="#142B86"> valentina_Init( 10 * 1024 * 1024,"extremely_way_long_serial_number",,)</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"> DatabaseOpen<span class="Apple-style-span" style="color: rgb(0, 0, 0); font-style: normal; "><span style=""><i><font class="Apple-style-span" color="#142B86"></font></i></span></span></font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"><span class="Apple-style-span" style="color: rgb(0, 0, 0); font-style: normal; "><span style=""><i><font class="Apple-style-span" color="#142B86">end</font></i></span><i><font class="Apple-style-span" color="#142B86"> mouseUp</font></i></span></font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"><br></font></i></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">
<i><font class="Apple-style-span" color="#142B86">on DatabaseOpen</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica; min-height: 14.0px"><i><font class="Apple-style-span" color="#142B86"><br></font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"> put VDatabase_Constructor() into gDatabase</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"> -- Build db full path near to stack:</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"> get the effective filename of this stack</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"> set the itemdel to slash</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"> put the (item 1 to -2 of it) & slash & "MyDatabase.vdb" into dbPath</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86"> get VDatabase_Open( gDatabase, dbPAth )</font></i></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">
<i><font class="Apple-style-span" color="#142B86"> -- Put the make sure system date is set stuff here?</font></i></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial">
<i><font class="Apple-style-span" color="#142B86"> VDatabase_DateFormat( </font></i><span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; "><i><font class="Apple-style-span" color="#142B86">gDatabase</font></i></span><i><font class="Apple-style-span" color="#142B86">,"kYMD" ) -- specifies the format of date.</font></i></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial"><i><font class="Apple-style-span" color="#142B86"> VDatabase_DateSep( </font></i><span class="Apple-style-span" style="font-family: Helvetica; font-size: 12px; "><i><font class="Apple-style-span" color="#142B86">gDatabase</font></i></span><i><font class="Apple-style-span" color="#142B86">f, "-" ) -- separator for date</font></i></p>
<p></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><font class="Apple-style-span" face="arial" size="3"><span class="Apple-style-span" style="border-collapse: collapse; font-size: 13px;"><i><font class="Apple-style-span" color="#142B86"> -- Always set the date format everytime you open the database?</font></i></span></font></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><i><font class="Apple-style-span" color="#142B86">end DatabaseOpen</font></i></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><br></p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">Thanks for your help...</p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica"><br></p><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 12.0px Helvetica">
Bill</p><p></p>
<br><div class="gmail_quote">On Tue, Jul 22, 2008 at 2:17 PM, Joseph Morgan <<a href="mailto:joseph@checkos.com">joseph@checkos.com</a>> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
I thought you have to set the date for the database each time you open<br>
it no matter what. I always use yyyy-mm-dd. But no matter the<br>
platform, the date always reverts to something else. This is the case<br>
in vstudio and outside of vstudio (ie. realbasic or perhaps runrev). I<br>
don't think this is a bug as I am pretty sure I recall Ruslan stating<br>
that this was the intended behavior. I always run the following sql<br>
command on any database right after opening it and it always works for<br>
me:<br>
<br>
SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO<br>
'kYMD','-',':';<br>
<br>
You may want to check out the wiki for more info but I think kMDY<br>
would give you the mm/dd/yy dates then set your date separator and<br>
that should work.<br>
<br>
<br>
Joseph<br>
<div><div></div><div class="Wj3C7c"><br>
On Jul 22, 2008, at 12:17 PM, william humphrey wrote:<br>
<br>
> To add to system date and Valentina Studio date "funkiness". On an<br>
> Intel Mac which has the U.S. system date (no attempt to set a custom<br>
> system date to match YYYY-MM-DD there is no problem with the<br>
> settings in Valentina Studio and the settings in the database<br>
> changing by themselves back to mm/dd/yy.<br>
><br>
> But it appears to happen on the older G4 Mac even to a database that<br>
> is moved back and forth and used in RunRev without opening it in<br>
> vStudio. There is no way I can report this to Mantis yet as I<br>
> haven't figured out exactly what is causing the database to change<br>
> the date settings on their own back to mm/dd/yy but it is an<br>
> important bug as all sorts of crashes result when the data in the<br>
> date fields are formated yyyy-mm-dd and the database is expecting<br>
> them to be mm/dd/yy.<br>
><br>
> Has anyone else encountered this date setting weirdness? For me it<br>
> is limited to the G4 mac running OS 10.4 and does not happen on the<br>
> Intel Mac running OS 10.5<br>
</div></div>> _______________________________________________<br>
> Valentina-studio mailing list<br>
> <a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br>
> <a href="http://lists.macserve.net/mailman/listinfo/valentina-studio" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-studio</a><br>
<br>
_______________________________________________<br>
Valentina-studio mailing list<br>
<a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina-studio" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-studio</a><br>
</blockquote></div><br><br clear="all"><br>-- <br><a href="http://www.bluewatermaritime.com">http://www.bluewatermaritime.com</a>
</div></div></div>