<div dir="ltr"><br><br><div class="gmail_quote"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr"><div><div class="Wj3C7c"><div class="gmail_quote"><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 can do this:</div></div></blockquote></div></div></div></div></blockquote><div><br></div><p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial">VDatabase_SqlExecute(</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial">dbRef,</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial">inStrCommand,</p>
<p style="margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Arial">inBinds = nil )</p>
<div><br></div><div><font class="Apple-style-span" size="3"><span class="Apple-style-span" style="font-size: 13px;"><br></span></font></div><div>I'll try this next but still if someone would tell me how to get the other functions working I'd appreciate it :)</div>
<div><br></div><p style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; font: normal normal normal 11px/normal Arial; ">VDatabase_SqlExecute(</p><div><span class="Apple-style-span" style="font-family: Arial; font-size: 12px; ">dbRef,</span>"SET PROPERTY DateTimeFormat,DateSeparator,TimeSeparator OF DATABASE TO 'kYMD','-',':'")</div>
<div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><div dir="ltr"><div><div class="Wj3C7c"><div class="gmail_quote"><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></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></div></blockquote></div><br></div><br><br></blockquote></div></div></div></div></blockquote></div></div>