ISDBDatabase::OpenSQL: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
(No difference)
|
Revision as of 14:37, 21 March 2007
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