From MediaMonkey Wiki
Revision as of 22:51, 20 April 2013 by Michal.kocarek (talk | contribs) (note about locking errors, style)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

CoClass SDBDatabase, Interface ISDBDatabase

Function OpenSQL(SQL As String) As SDBDBIterator


Name Type Description
SQL String SQL string specifying the query.

Method description

Returns SDBDBIterator object with records specified by SQL parameter.

Example code

Set Iterator = SDB.Database.OpenSQL("SELECT DISTINCT TextData FROM AddSongInfo WHERE DataType=200 Order BY TextData")

While Not Iterator.EOF
   ' Do something here ...
Set Iterator = Nothing ' Avoid locking errors