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()