ISDBDatabase::ExecSQL

CoClass SDBDatabase, Interface ISDBDatabase

Sub ExecSQL(SQL As String)

Parameters

Name	Type	Description
SQL	String	Full SQL to be executed

Method description

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.

Example code

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