ISDBDatabase::QuerySongs: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
m (Argument can't start with "AND " anymore) |
||
| Line 4: | Line 4: | ||
{{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 or possible. | ||
[[Category:Scripting|{{PAGENAME}}]] | [[Category:Scripting|{{PAGENAME}}]] | ||
Revision as of 11:18, 6 September 2007
CoClass SDBDatabase, Interface ISDBDatabase
Function QuerySongs(AddSQL As String) As Object
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 or possible.
