ISDBDatabase::OpenSQL

From MediaMonkey Wiki

Revision as of 14:37, 21 March 2007 by Jiri (talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to navigation Jump to search

CoClass SDBDatabase, Interface ISDBDatabase

Function OpenSQL(SQL As String) As Object

Parameters

Name	Type	Description
SQL	String	SQL string specifying the query.

Method description

Returns SDBDBIterator object with records specified by SQL parameter.

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 "https://www.mediamonkey.com/wiki/index.php?title=ISDBDatabase::OpenSQL&oldid=1529"