SqlPrepare Function

[NeedsAccessToLocalsAttribute(TRUE)]
 FUNCTION SqlPrepare(
	nStatementHandle AS LONG,
	cSQLCommand AS STRING,
	 cCursorName AS STRING
) AS LONG

[NeedsAccessToLocalsAttribute(true)]
public static int SqlPrepare(
	int nStatementHandle,
	string cSQLCommand,
	[DefaultParameterValueAttribute("SQLRESULT", 0)] string cCursorName
)

Parameters

nStatementHandle

Type: Long
Specifies the statement handle to the data source returned by SqlConnect( ).

cSQLCommand

Type: String
Specifies the SQL statement passed to the data source.
The SQL statement can contain a parameterized Where clause, which creates a parameterized view. All parameters in the Where clause must be defined before SqlPrepare( ) is issued. For example, if the parameters are variables, the variables must be created and initialized before SqlPrepare( ) is issued.

Tip
Parameterized queries are not yet supported in X#

cCursorName

Type: String
Specifies the name of the X# cursor to which the result set is sent. If you don't include a cursor name, X# uses the default name SQLRESULT.
For multiple result sets, new cursor names are derived by appending an incremented number to the name of the first cursor.

Return Value

Reference