SQLStatement Class |  |
Manage a SQL statement.
Inheritance HierarchyNamespace: VO
Assembly: VOSQLClasses (in VOSQLClasses.dll) Version: 2.19
SyntaxThe SQLStatement type exposes the following members.
Constructors| Name | Description | |
|---|---|---|
  | SQLStatement |
Construct a SQLStatement object.
|
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.
|
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.
|
Examples
The following example demonstrates the use of the SQLStatement class:
X#
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()
See Also