ISDBDatabase::ExecSQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 8: | Line 8: | ||
===Method description=== | ===Method description=== | ||
Executes SQL in | 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=== | ===Example code=== | ||
Latest revision as of 21:57, 4 February 2008
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