<div dir="ltr">This to try:<div><br></div><div><pre class="" style="border:1px solid rgb(136,136,136);font-family:inherit;margin-top:0px;margin-bottom:0px;outline:0px;padding:2px;list-style-type:none;word-wrap:normal;direction:ltr;min-height:70px;color:rgb(51,51,51);font-size:14px;line-height:20.162017822265625px"><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,136)">SELECT</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">
SERVERPROPERTY</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">(</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,136,0)">'MachineName'</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">)</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,136)">AS</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">[</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">ServerName</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">],</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">
SERVERPROPERTY</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">(</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,136,0)">'ServerName'</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">)</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,136)">AS</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">[</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">ServerInstanceName</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">],</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">
SERVERPROPERTY</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">(</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,136,0)">'InstanceName'</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">)</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,136)">AS</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">[</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">Instance</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">],</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">
SERVERPROPERTY</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">(</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,136,0)">'Edition'</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">)</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,136)">AS</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">[</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">Edition</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">],</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">
SERVERPROPERTY</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">(</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,136,0)">'ProductVersion'</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">)</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,136)">AS</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">[</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">ProductVersion</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">],</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">
</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,136)">Left</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">(@@</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">Version</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">,</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> Charindex</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">(</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,136,0)">'-'</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">,</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">@@</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)">version</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">)</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">-</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,102,102)">2</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(102,102,0)">)</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> </span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,136)">As</span><span class="" style="border:0px;font-style:inherit;font-family:inherit;margin:0px;outline:0px;padding:0px;color:rgb(0,0,0)"> VersionName</span></pre></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Sep 23, 2015 at 3:02 PM, 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">is there a SQL command that will return the name of the database server host? I want to use just dbREF and not serverRef or dbInfoRef as I get crashes with those commands (I will work up a Manta report sometime later). It's really a shame that <b style="color:rgb(0,142,0);font-family:'Helvetica Neue';font-size:11px">DataBase_Path(dbRef does not actually return the path to the database and only returns the database name.</b></div><div class="gmail_extra"><div><div class="h5"><br><div class="gmail_quote">On Sat, Sep 19, 2015 at 3:40 AM, Ivan Smahin <span dir="ltr"><<a href="mailto:ivan_smahin@paradigmasoft.com" target="_blank">ivan_smahin@paradigmasoft.com</a>></span> 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"><span><span style="color:rgb(51,51,51);font-size:12px;line-height:18px;text-align:justify;background-color:rgb(247,249,250)">put VConnection_Constructor( "localhost", "sa", "sa") into mConn</span></span><div><div style="text-align:justify"><font color="#333333"><span style="font-size:12px;line-height:18px;background-color:rgb(247,249,250)">...</span></font></div><div><div style="text-align:justify"><div style="text-align:start"><div style="margin:0px;font-size:11px;font-family:Menlo">put VServer_New( <span style="color:rgb(51,51,51);font-family:Helvetica;font-size:12px;line-height:18px;text-align:justify;background-color:rgb(247,249,250)">mConn</span> ) into serverRef</div></div><div style="text-align:start">put 1 into dbIndex</div><div style="text-align:start"><span><div style="margin:0px;font-size:11px;font-family:Menlo">put VServer_DatabaseInfo( serverRef, dbIndex ) into dbInfoRef</div></span><div style="margin:0px;font-size:11px;font-family:Menlo">...</div><div style="margin:0px;font-size:11px;font-family:Menlo"><br></div></div></div></div></div><div><blockquote type="cite"><div><div><div>On Sep 18, 2015, at 6:26 PM, william humphrey <<a href="mailto:bill@bluewatermaritime.com" target="_blank">bill@bluewatermaritime.com</a>> wrote:</div><br></div></div><div><div><div><div dir="ltr" style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">never mind. I got confused as to what version of Valentina is the most recent. So I'm still getting crashes. Instead of this old method<div><br></div><div><div>It should be something like this one:</div><div><br></div><div><div style="margin:0px;font-size:11px;font-family:Menlo">put VServer_New( connectionRef ) into serverRef</div></div><div>put 1 into dbIndex</div><div><div style="margin:0px;font-size:11px;font-family:Menlo">put VServer_DatabaseInfo( serverRef, dbIndex ) into dbInfoRef</div><div><br></div><div>I would like to use something like</div><div><div style="margin:0px;font-size:11px;font-family:'Helvetica Neue'"><span style="color:rgb(145,143,0)"><b>put</b></span><span> </span>VConnection_Constructor(gDbServer2,<span> </span><span style="color:rgb(1,24,146)">"sa"</span>,<span> </span><span style="color:rgb(1,24,146)">"sa"</span>,<span> </span><span style="color:rgb(1,24,146)">15432</span>)<span> </span><span style="color:rgb(147,33,146)">into</span> <span style="font-family:Menlo">serverRef</span></div><div>put 1 into dbIndex</div><div><div style="margin:0px;font-size:11px;font-family:Menlo">put VServer_DatabaseInfo( serverRef, dbIndex ) into dbInfoRef</div></div></div><div style="margin:0px;font-size:11px;font-family:Menlo"><br></div><div style="margin:0px;font-size:11px;font-family:Menlo">But this crashes LiveCode every time.</div><span style="font-size:13px"></span></div></div></div><div class="gmail_extra" style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><br><div class="gmail_quote">On Fri, Sep 18, 2015 at 11:15 AM, william humphrey<span> </span><span dir="ltr"><<a href="mailto:bill@bluewatermaritime.com" target="_blank">bill@bluewatermaritime.com</a>></span><span> </span>wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra">Is <span style="color:rgb(51,51,51);font-size:12px;line-height:18px;text-align:justify;background-color:rgb(247,249,250)"><span> </span>put VConnection_Constructor( "localhost", "sa", "sa") into mConn</span></div><div class="gmail_extra"><span style="color:rgb(51,51,51);font-size:12px;line-height:18px;text-align:justify;background-color:rgb(247,249,250)">replaced by </span></div><div class="gmail_extra"><div title="Page 173"><div><div><p><span style="font-size:11pt;font-family:ArialMT">put VServer_New( "localhost", "sa", "sa" ) into srvRef</span></p><p><span style="font-size:11pt;font-family:ArialMT">I don't see any reference to any VConnection commands in</span></p><div><br></div><div title="Page 1"><div><div><p><span style="font-size:36pt;font-family:Arial;font-weight:700;font-style:italic">VALENTINA 3<span> </span></span><span style="font-size:24pt;font-family:Arial;font-weight:700;font-style:italic">for Revolution Reference</span></p><p><span style="font-family:Arial;font-size:24pt;font-style:italic;font-weight:700">this is pretty important to know as I should change the way I connect to the valentina database server with this new method and maybe a lot of my problems will be solved. </span><br></p></div></div></div><div><span style="font-size:11pt;font-family:ArialMT"> </span><br></div></div></div></div></div><div class="gmail_extra"><br></div><div class="gmail_extra"><span><br><div class="gmail_quote">On Fri, Sep 18, 2015 at 2:45 AM, Ivan Smahin<span> </span><span dir="ltr"><<a href="mailto:ivan_smahin@paradigmasoft.com" target="_blank">ivan_smahin@paradigmasoft.com</a>></span><span> </span>wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><div>put 1 into dbIndex</div><div><div style="margin:0px;font-size:11px;font-family:Menlo">put VServer_DatabaseInfo( serverRef, dbIndex ) into dbInfoRef</div><span><div style="margin:0px;font-size:11px;font-family:Menlo"></div></span></div></blockquote></div><br><br><br clear="all"><div><br></div></span><span><font color="#888888">--<span> </span><br><div><a href="http://www.bluewatermaritime.com/" target="_blank">http://www.bluewatermaritime.com</a></div></font></span></div></div></blockquote></div><br><br clear="all"><div><br></div>--<span> </span><br><div><a href="http://www.bluewatermaritime.com/" target="_blank">http://www.bluewatermaritime.com</a></div></div></div></div><span style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">_______________________________________________</span><br style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><span style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">Valentina mailing list</span><br style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><a href="mailto:Valentina@lists.macserve.net" style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" target="_blank">Valentina@lists.macserve.net</a><br style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><a href="http://lists.macserve.net/mailman/listinfo/valentina" style="font-family:Helvetica;font-size:14px;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a></div></blockquote></div><span><br><div>
<span style="border-collapse:separate;color:rgb(0,0,0);font-family:Helvetica;font-style:normal;font-variant:normal;font-weight:normal;letter-spacing:normal;line-height:normal;text-align:-webkit-auto;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px"><div>-- <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></div></span>
</div>
<br></span></div><br>_______________________________________________<br>
Valentina mailing list<br>
<a href="mailto:Valentina@lists.macserve.net" target="_blank">Valentina@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina" rel="noreferrer" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina</a><br>
<br></blockquote></div><br><br clear="all"><div><br></div>-- <br></div></div><div><a href="http://www.bluewatermaritime.com" target="_blank">http://www.bluewatermaritime.com</a></div>
</div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br><div class="gmail_signature"><a href="http://www.bluewatermaritime.com" target="_blank">http://www.bluewatermaritime.com</a></div>
</div>