<div dir="ltr">Thanks for the quick answer. I can try that but it would be so much better if the built in valentina functions worked. I'm going to try asking this on the Runtime Revolution list also.<br><br><div class="gmail_quote">
On Wed, Jul 23, 2008 at 11:24 AM, Joseph Morgan <<a href="mailto:joseph@checkos.com" target="_blank">joseph@checkos.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div>I'm not sure how runrev works so I can't help you with that. </div><div>
<br></div><div>Is there a way for you to send an sql command to the the database similar to how you send a select statement?</div><div><br></div><div>in realbasic I do the following:</div><div><br></div><div>myVDatabase.SQLExecute("SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO 'kYMD','-',':'")</div>
<div><br></div><font color="#888888"><div><br></div><div><br></div><div>Joseph</div><br></font><div><div><div></div><div><div>On Jul 23, 2008, at 6:26 AM, william humphrey wrote:</div><br></div></div><blockquote type="cite">
<div><div></div><div><div dir="ltr">Well I just tried<div><br></div><div><span style="border-collapse:collapse"><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"> <i><font color="#142B86"> VDatabase_DateFormat( </font></i><span style="font-family:Helvetica;font-size:12px"><i><font color="#142B86">gDatabase</font></i></span><i><font color="#142B86">,"kYMD" ) -- specifies the format of date.</font></i></div>
<div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><i><font color="#142B86"> VDatabase_DateSep( </font></i><span style="font-family:Helvetica;font-size:12px"><i><font color="#142B86">gDatabase</font></i></span><i><font color="#142B86">f, "-" ) -- separator for date</font></i></div>
<div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><font color="#142B86"><i><br></i></font></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"> <font color="#142B86"><i>in RunRev and I get the error message "can't find handler" which means that this must have been changed to something else but that change isn't in the V4REV _reference</i></font></div>
<div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><font color="#142B86"><i><br></i></font></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"> <font color="#142B86"><i>Does anyone know what it should be?</i></font></div>
<div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"> <font color="#142B86"><i><br></i></font></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><font color="#142B86"><i>Thanks</i></font></div>
<div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"><font color="#142B86"><i><br></i></font></div><div style="margin-top:0px;margin-right:0px;margin-bottom:0px;margin-left:0px"> <font color="#142B86"><i>Bill</i></font></div>
</span></div></div></div></div><div> _______________________________________________<br>Valentina-studio mailing list<br><a href="mailto:Valentina-studio@lists.macserve.net" target="_blank">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></div></blockquote></div><br></div><br>_______________________________________________<br>
Valentina-studio mailing list<br>
<a href="mailto:Valentina-studio@lists.macserve.net" target="_blank">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></blockquote></div><br><br clear="all"><br>-- <br><a href="http://www.bluewatermaritime.com" target="_blank">http://www.bluewatermaritime.com</a>
</div>