https://www.mediamonkey.com/wiki/index.php?action=history&feed=atom&title=ISDBDatabase%3A%3AExecSQL 2026-05-05T16:03:10Z Revision history for this page on the wiki MediaWiki 1.41.4 https://www.mediamonkey.com/wiki/index.php?title=ISDBDatabase::ExecSQL&diff=3195&oldid=prev 2008-02-04T21:57:52Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 21:57, 4 February 2008</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l8">Line 8:</td> <td colspan="2" class="diff-lineno">Line 8:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Method description===</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Method description===</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Executes SQL in <del style="font-weight: bold; text-decoration: none;">the MS Access </del>database <del style="font-weight: bold; text-decoration: none;">that is </del>used for <del style="font-weight: bold; text-decoration: none;">Library storage</del>. In order to understand how to construct such SQL commands you have to know SQL language and the structure of MM database.</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Does not return anything. The method </ins>Executes SQL in <ins style="font-weight: bold; text-decoration: none;">MediaMonkey's </ins>database<ins style="font-weight: bold; text-decoration: none;">. Mainly </ins>used for <ins style="font-weight: bold; text-decoration: none;">UPDATE, INSERT and DELETE statements</ins>.  </div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>In order to understand how to construct such SQL commands you have to know SQL language and the structure of MM database. <ins style="font-weight: bold; text-decoration: none;">[[MediaMonkey Database structure]]</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Example code===                     </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>===Example code===                     </div></td></tr> </table>

Bex https://www.mediamonkey.com/wiki/index.php?title=ISDBDatabase::ExecSQL&diff=1528&oldid=prev 2007-03-21T14:37:04Z

<p></p> <p><b>New page</b></p><div>{{MethodDeclaration|SDBDatabase|ISDBDatabase|Sub ExecSQL(SQL As String)}}<br /> <br /> ===Parameters===<br /> <br /> {{MethodParameters <br /> |SQL |String |Full SQL to be executed}}<br /> <br /> ===Method description===<br /> <br /> Executes SQL in the MS Access database that is used for Library storage. In order to understand how to construct such SQL commands you have to know SQL language and the structure of MM database.<br /> <br /> ===Example code=== <br /> &lt;source lang=&quot;vb&quot;&gt;SDB.Database.ExecSQL( &quot;UPDATE Songs SET PlayCounter=0&quot;) &#039; Clears # played of all tracks in the library&lt;/source&gt;<br /> <br /> [[Category:Scripting|{{PAGENAME}}]]<br /> [[Category:Automation objects|{{PAGENAME}}]]<br /> [[Category:CoClass SDBDatabase|{{PAGENAME}}]]<br /> [[Category:Interface ISDBDatabase|{{PAGENAME}}]]</div>

Jiri