ISDBDatabase::QuerySongs: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{MethodDeclaration|SDBDatabase|ISDBDatabase|Function QuerySongs(AddSQL As String) As | {{MethodDeclaration|SDBDatabase|ISDBDatabase|Function QuerySongs(AddSQL As String) As SDBSongIterator}} | ||
===Parameters=== | ===Parameters=== | ||
{{MethodParameters | {{MethodParameters | ||
|AddSQL |String |Only condition part of SQL statement | |AddSQL |String |Only condition part of SQL statement (WHERE clause)}} | ||
===Method description=== | ===Method description=== | ||
Returns a [[SDBSongIterator]] object with a list of tracks | Returns a [[SDBSongIterator]] object with a list of tracks fulfilling criteria specified by AddSQL parameter. | ||
===Example code=== | ===Example code=== | ||
<source lang="vb"> | <source lang="vb"> | ||
Set Iter = SDB.Database.QuerySongs( "SongLength>60*1000") | Set Iter = SDB.Database.QuerySongs("SongLength > 60*1000") | ||
</source> | </source> | ||
===Older versions=== | ===Older versions=== | ||
In MediaMonkey prior version 3.0 the AddSQL string had to start with | In MediaMonkey prior version 3.0 the AddSQL string had to start with "AND ", but this is no longer needed. | ||
[[Category:Scripting|{{PAGENAME}}]] | [[Category:Scripting|{{PAGENAME}}]] | ||
Latest revision as of 21:08, 11 October 2011
CoClass SDBDatabase, Interface ISDBDatabase
Function QuerySongs(AddSQL As String) As SDBSongIterator
Parameters
| Name | Type | Description |
|---|---|---|
| AddSQL | String | Only condition part of SQL statement (WHERE clause) |
Method description
Returns a SDBSongIterator object with a list of tracks fulfilling criteria specified by AddSQL parameter.
Example code
Set Iter = SDB.Database.QuerySongs("SongLength > 60*1000")Older versions
In MediaMonkey prior version 3.0 the AddSQL string had to start with "AND ", but this is no longer needed.
