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, 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