ISDBDatabase::ExecSQL

CoClass SDBDatabase, Interface ISDBDatabase

Sub ExecSQL(SQL As String)

Parameters

Name	Type	Description
SQL	String	Full SQL to be executed

Method description

Does not return anything. The method Executes SQL in MediaMonkey's database. Mainly used for UPDATE, INSERT and DELETE statements. In order to understand how to construct such SQL commands you have to know SQL language and the structure of MM database. MediaMonkey Database structure

Example code

SDB.Database.ExecSQL( "UPDATE Songs SET PlayCounter=0")   ' Clears # played of all tracks in the library