Michal.kocarek: note about locking errors, style

2013-04-20T22:51:17Z

note about locking errors, style

← Older revision		Revision as of 22:51, 20 April 2013
Line 1:		Line 1:
	{{MethodDeclaration\|SDBDatabase\|ISDBDatabase\|Function OpenSQL(SQL As String) As ~~Object~~}}		{{MethodDeclaration\|SDBDatabase\|ISDBDatabase\|Function OpenSQL(SQL As String) As [[SDBDBIterator]]}}

	===Parameters===		===Parameters===
Line 12:		Line 12:
	===Example code===		===Example code===
	<source lang="vb">		<source lang="vb">
	Set ~~Iter~~ = SDB.Database.OpenSQL( "SELECT DISTINCT TextData FROM AddSongInfo WHERE DataType=200 Order BY TextData")		Set Iterator = SDB.Database.OpenSQL("SELECT DISTINCT TextData FROM AddSongInfo WHERE DataType=200 Order BY TextData")

	While Not ~~Iter~~.EOF		While Not Iterator.EOF
	' do something here....		' Do something here ...
	~~Iter~~.Next		Iterator.Next
	WEnd		WEnd
			Set Iterator = Nothing ' Avoid locking errors
	</source>		</source>

Jiri at 14:37, 21 March 2007

2007-03-21T14:37:34Z

New page

{{MethodDeclaration|SDBDatabase|ISDBDatabase|Function OpenSQL(SQL As String) As Object}}

===Parameters===

{{MethodParameters
|SQL |String |SQL string specifying the query.}}

===Method description===

Returns [[SDBDBIterator]] object with records specified by SQL parameter.

===Example code===
<source lang="vb">
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
</source>

[[Category:Scripting|{{PAGENAME}}]]
[[Category:Automation objects|{{PAGENAME}}]]
[[Category:CoClass SDBDatabase|{{PAGENAME}}]]
[[Category:Interface ISDBDatabase|{{PAGENAME}}]]

ISDBDatabase::OpenSQL - Revision history

Michal.kocarek: note about locking errors, style

Jiri at 14:37, 21 March 2007