ISDBDatabase::OpenSQL

From MMWiki

Jump to: navigation, search

CoClass SDBDatabase, Interface ISDBDatabase

Function OpenSQL(SQL As String) As Object


[edit]

Parameters

Name Type Description
SQL String SQL string specifying the query.


[edit]

Method description

Returns SDBDBIterator object with records specified by SQL parameter.

[edit]

Example code

Set Iter = SDB.Database.OpenSQL( "SELECT DISTINCT TextData FROM AddSongInfo WHERE DataType=200 Order BY TextData")
 
While Not Iter.EOF
   ' do something here....
  Iter.Next
WEnd
Retrieved from "http://www.mediamonkey.com/wiki/index.php/ISDBDatabase::OpenSQL"