SQLStatement Class (Typed) | ![]() |
Namespace: XSharp.VO.SDK
The SQLStatement type exposes the following members.
Name | Description | |
---|---|---|
![]() ![]() | SQLStatement |
Construct a SQLStatement object.
|
Name | Description | |
---|---|---|
![]() | Connection |
The data source — a SQLConnection object — that this statement is connected to.
|
![]() | CursorType | Obsolete. |
![]() | 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 | Obsolete. |
![]() | 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 | Obsolete. |
![]() | Schema | |
![]() | ScrollConcurrency | Obsolete. |
![]() | SimulateCursor | Obsolete. |
![]() | 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.
|
![]() | Table |
Name | Description | |
---|---|---|
![]() | _CreateDBParameter | |
![]() | Commit |
Save the changes made since the last Commit().
|
![]() | Destroy | |
![]() ![]() | Execute |
Execute the statement.
|
![]() ![]() | FillErrorHandler | |
![]() | FreeStmt |
Free the statement, according to the specified option.
|
![]() | GetStatementOption | Obsolete.
Return current setting for a statement option or NIL, if an error occurred.
|
![]() | MakeErrorInfo | |
![]() | Prepare |
Prepare a statement.
|
![]() | SetStatementOption | Obsolete.
Set current setting for a statement option.
|
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()