ISDBDatabase::ExecSQL

From MediaMonkey Wiki
Jump to: navigation, search

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