<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><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><div><br></div><div><br></div><div>Joseph</div><br><div><div>On Jul 23, 2008, at 6:26 AM, william humphrey wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div dir="ltr">Well I just tried<div><br></div><div><span class="Apple-style-span" style="border-collapse: collapse; "><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "> <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; font: normal normal normal 11px/normal Arial; "><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: normal normal normal 11px/normal Arial; "><font class="Apple-style-span" color="#142B86"><i><br></i></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "> <font class="Apple-style-span" 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: normal normal normal 11px/normal Arial; "><font class="Apple-style-span" color="#142B86"><i><br></i></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "> <font class="Apple-style-span" 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: normal normal normal 11px/normal Arial; "> <font class="Apple-style-span" color="#142B86"><i><br></i></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "><font class="Apple-style-span" color="#142B86"><i>Thanks</i></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "><font class="Apple-style-span" color="#142B86"><i><br></i></font></div><div style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; "> <font class="Apple-style-span" color="#142B86"><i>Bill</i></font></div></span></div></div> _______________________________________________<br>Valentina-studio mailing list<br><a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina-studio<br></blockquote></div><br></body></html>