ISDBDatabase::GetAutoPlaylistQuery: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
m (Code clean-up) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
{{MethodDeclaration|SDBDatabase|ISDBDatabase|Function GetAutoPlaylistQuery(ID As Integer) As String}} | {{MethodDeclaration|SDBDatabase|ISDBDatabase|Function GetAutoPlaylistQuery(ID As Integer) As String}} | ||
===Parameters=== | === Parameters === | ||
{{MethodParameters | {{MethodParameters | ||
|ID |Integer |ID of specified auto-playlist}} | |ID |Integer |[[ISDBPlaylist::ID|ID]] of specified auto-playlist}} | ||
===Method description=== | === Method description === | ||
Returns SQL query used by specified auto-playlist. | Returns SQL query used by specified auto-playlist. | ||
Introduced in MediaMonkey 4.0 | ''Introduced in MediaMonkey 4.0.'' | ||
=== Example code === | |||
<source lang="vb"> | <source lang="vb"> | ||
Dim res, iter | |||
If SDB.MainTree.CurrentNode.NodeType = 71 Then ' 71 = Auto-Playlist | |||
Set Iter = SDB.Database.OpenSQL(SDB.Database.GetAutoPlaylistQuery(SDB.MainTree.CurrentNode.RelatedObjectID)) | |||
While Not Iter.EOF | |||
' do something here.... | |||
Iter.Next | |||
Wend | |||
Else | |||
res = SDB.MessageBox("You must select Auto-Playlist!", mtError, Array(mbOk)) | |||
End If | |||
</source> | </source> | ||
[[Category:Scripting|{{PAGENAME}}]] | [[Category:Scripting|{{PAGENAME}}]] [[Category:Automation_objects|{{PAGENAME}}]] [[Category:CoClass_SDBDatabase|{{PAGENAME}}]] [[Category:Interface_ISDBDatabase|{{PAGENAME}}]] | ||
[[Category: | |||
[[Category: | |||
[[Category: | |||
Latest revision as of 18:41, 20 April 2013
CoClass SDBDatabase, Interface ISDBDatabase
Function GetAutoPlaylistQuery(ID As Integer) As String
Parameters
| Name | Type | Description |
|---|---|---|
| ID | Integer | ID of specified auto-playlist |
Method description
Returns SQL query used by specified auto-playlist.
Introduced in MediaMonkey 4.0.
Example code
Dim res, iter
If SDB.MainTree.CurrentNode.NodeType = 71 Then ' 71 = Auto-Playlist
Set Iter = SDB.Database.OpenSQL(SDB.Database.GetAutoPlaylistQuery(SDB.MainTree.CurrentNode.RelatedObjectID))
While Not Iter.EOF
' do something here....
Iter.Next
Wend
Else
res = SDB.MessageBox("You must select Auto-Playlist!", mtError, Array(mbOk))
End If