SQLStatement Class

Manage a SQL statement.

Inheritance Hierarchy

Object
SQLStatement

Namespace: VO
Assembly: VOSQLClasses (in VOSQLClasses.dll) Version: 2.21

Syntax

Copy

 CLASS SQLStatement

public class SQLStatement

Request Example View Source

The SQLStatement type exposes the following members.

Constructors

	Name	Description
	SQLStatement	Construct a SQLStatement object.

Top

Properties

	Name	Description
	Connection	The data source — a SQLConnection object — that this statement is connected to.
	CursorType
	ErrInfo	An SQL statement error information (SQLErrorInfo) object. Use the error flag of the returned object to determine if an error occurred.
	HyperLabel	A hyperlabel containing a description of the statement.
	KeySet
	NativeSQL	A string containing the native text of the statement. Level 2
	NumParameters	A numeric value containing the number of parameters in the statement. A return value of -1 indicates an error. Level 2
	NumSuccessfulRows	A numeric value containing the number of rows that were affected by the insert, update, or delete statement. A return value of -1 indicates an error.
	Params
	PrepFlag	A logical value that indicates if the statement has been prepared.
	RecCount
	RowSet
	ScrollConcurrency
	SimulateCursor
	SQLString	A string containing the text of the statement.
	StatementHandle	A long integer representing the statement handle.
	Status	A hyperlabel describing the error, or NULL_OBJECT if no error has occurred.

Top

Methods

	Name	Description
	Commit	Save the changes made since the last Commit().
	Destroy
	Execute	Execute the statement.
	FreeStmt	Free the statement, according to the specified option.
	GetStatementOption	Return current setting for a statement option or NIL, if an error occurred.
	MakeErrorInfo
	Prepare	Prepare a statement.
	RollBack	Undo the changes made since the last Commit().
	SetStatementOption	Set current setting for a statement option.

Top

Examples

The following example demonstrates the use of the SQLStatement class:

Copy

 1FUNCTION CreateTable()
 2LOCAL oStmt AS SQLStatement
 3LOCAL oConn AS SQLConnection
 4oConn := SQLConnection{"sample","dba","sql"}
 5oStmt := SQLStatement{"Create table test ;
 6(Col1 INT,Col2 Char(10))", oConn}
 7IF !oStmt:Execute()
 8oStmt:ErrInfo:ShowErrorMsg()
 9ENDIF
10oStmt:FreeStmt(SQL_DROP)
11oConn:Disconnect()

Reference

VO Namespace