The SalSqlHandle type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
 | ClearContext |
Clears the sql context.
|
| CloseAllSPResultSets |
Closes any result sets generated by the execution of a stored procedure.
|
| CloseResultSet |
Closes the result set.
|
| Commit()()()() |
Commits all of the SQL transaction's cursors that are connected to the same database.
|
| Commit(WhenSqlErrorHandler) |
Commits all of the SQL transaction's cursors that are connected to the same database.
|
| Connect()()()() |
Connects to a database.
Uses Sql.Database, Sql.User and Sql.Password.
|
| Connect(WhenSqlErrorHandler) |
Connects to a database.
Uses Sql.Database, Sql.User and Sql.Password.
|
| Connect(String, String, String) |
Connects to a database.
|
 | DirectoryByName |
Returns the database names on the specified server.
|
| Disconnect()()()() |
Disconnects from a database.
|
| Disconnect(WhenSqlErrorHandler) |
Disconnects from a database.
|
| Equals |
Overrides the Object.Equals() method.
(Overrides ValueType..::..Equals(Object).) |
| Execute()()()() |
Executes a SQL statement that was prepared with SqlPrepare or retrieved with SqlRetrieve.
|
| Execute(WhenSqlErrorHandler) |
Executes a SQL statement that was prepared with SqlPrepare or retrieved with SqlRetrieve.
|
| FetchNext()()()() |
Fetches the next row in a result set.
|
| FetchNext(SalNumber%) |
Fetches the next row in a result set.
|
| FetchNext(WhenSqlErrorHandler) |
Fetches the next row in a result set.
|
| FetchNext(SalNumber%, WhenSqlErrorHandler) |
Fetches the next row in a result set.
|
| FetchPrevious()()()() |
Fetches the previous row in a result set.
|
| FetchPrevious(SalNumber%) |
Fetches the previous row in a result set.
|
| FetchPrevious(WhenSqlErrorHandler) |
Fetches the previous row in a result set.
|
| FetchPrevious(SalNumber%, WhenSqlErrorHandler) |
Fetches the previous row in a result set.
|
| FetchRow(Int32) |
Fetches a row according at the absolute row position.
|
| FetchRow(Int32, SalNumber%) |
Fetches a row according at the absolute row position.
|
| FetchRow(Int32, WhenSqlErrorHandler) |
Fetches a row according at the absolute row position.
|
| FetchRow(Int32, SalNumber%, WhenSqlErrorHandler) |
Fetches a row according at the absolute row position.
|
| FromHandle |
Returns the SalSqlHandle object from the handle
|
| GetContext |
Returns the previously saved context for the sql handle.
|
| GetError |
Returns the last error information.
|
| GetErrorPosition()()()() |
Returns the offset of the error position within the last SQL statement.
|
| GetErrorPosition(SalNumber%) |
Returns the offset of the error position within the last SQL statement.
|
| GetHashCode |
Overrides the Object.GetHashCode() method
(Overrides ValueType..::..GetHashCode()()()().) |
| GetIsolationLevel |
Returns the isolation level.
|
| GetLastStatement |
Returns the last SQL statement used on this connection.
|
| GetModifiedRows()()()() |
Returns the number of rows affected by the most recent INSERT, UPDATE, or DELETE
statement.
|
| GetModifiedRows(SalNumber%) |
Returns the number of rows affected by the most recent INSERT, UPDATE, or DELETE
statement.
|
| GetNextSPResultSet(String) |
Returns the next result set returned by a stored procedure.
|
| GetNextSPResultSet(String, SalBoolean%) |
Returns the next result set returned by a stored procedure.
|
| GetObjectData | |
| GetParameter |
Gets the value of a database parameter.
|
| GetResultSetCount()()()() |
Returns the number of rows in the result set.
|
| GetResultSetCount(SalNumber%) |
Returns the number of rows in the result set.
|
| GetResultSetCount(WhenSqlErrorHandler) |
Returns the number of rows in the result set.
|
| GetResultSetCount(SalNumber%, WhenSqlErrorHandler) |
Returns the number of rows in the result set.
|
| GetSessionHandle()()()() |
This call returns the session handle to which the specified statement handle belongs.
The SqlHandle must have been created using SqlCreateStatement function and
not by calling SqlConnect function.
|
| GetSessionHandle(SalSqlSessionHandle%) |
This call returns the session handle to which the specified statement handle belongs.
The SqlHandle must have been created using SqlCreateStatement function and
not by calling SqlConnect function.
|
| GetStatementErrorInfo |
Returns the error information associated with the specified statement handle
(command/cursor).
|
| MoveNext |
Moves to the next row in the result set.
|
| MovePrev |
Moves to the previous row in the result set.
|
| OraPLSQLCommand(SalString) |
Executes an Oracle PL/SQL stored procedure. Supports dynamic arrays and recive
array parameters.
|
| OraPLSQLCommand(SalString, WhenSqlErrorHandler) |
Executes an Oracle PL/SQL stored procedure. Supports dynamic arrays and recive
array parameters.
|
| OraPLSQLExecute()()()() |
Executes the anonymous PL/SQL block that was prepared
using SqlOraPLSQLPrepare.
|
| OraPLSQLExecute(WhenSqlErrorHandler) |
Executes the anonymous PL/SQL block that was prepared
using SqlOraPLSQLPrepare.
|
| OraPLSQLPrepare(SalString) |
Compiles the anonymous PL/SQL block.
|
| OraPLSQLPrepare(SalString, WhenSqlErrorHandler) |
Compiles the anonymous PL/SQL block.
|
| Prepare(String) |
Compiles a SQL statement for execution.
|
| Prepare(String, WhenSqlErrorHandler) |
Compiles a SQL statement for execution.
|
| PrepareAndExecute(String) |
Compiles and executes a SQL statement.
|
| PrepareAndExecute(String, WhenSqlErrorHandler) |
Compiles and executes a SQL statement.
|
| PrepareSP(String, String) |
Prepares a stored procedure invokation statement.
|
| PrepareSP(String, String, WhenSqlErrorHandler) |
Prepares a stored procedure invokation statement.
|
| Read |
Returns an array with all the fields in the current row.
|
| Retrieve(String, String, String) |
Retrieves a SQLBase compiled command.
|
| Retrieve(String, String, String, WhenSqlErrorHandler) |
Retrieves a SQLBase compiled command.
|
| Rollback()()()() |
Executes a rollback on the current transaction.
|
| Rollback(WhenSqlErrorHandler) |
Executes a rollback on the current transaction.
|
| SetContext |
Sets the context to be used to resolve bind expressions.
|
| SetContextToForm()()()() |
Sets the context to be used to resolve bind expressions.
|
| SetContextToForm(Control) |
Sets the context to be used to resolve bind expressions.
|
| SetIsolationLevel |
Sets the isolation level.
|
| SetParameter |
Sets the value of a database parameter.
|
| SetResultSet |
Enables result sets.
|
| SetResultSetMode |
Defines the behvaior for the ResultSet mode.
|
| SetTimeout |
Specifies the maximum time to wait before generating an error.
|
| VarSetup |
Saves the sql bind variables context.
|
Operators
| Name | Description | |
|---|---|---|
 | Equality(SalSqlHandle, SalWindowHandle) |
== operator for comparing a SalSqlHandle to a SalWindowHandle
|
| Equality(SalSqlHandle, SalSqlHandle) |
== operator for comparing two SalSqlHandle objects
|
| Equality(SalWindowHandle, SalSqlHandle) |
== operator for comparing a SalSqlHandle to a SalWindowHandle
|
| ExplicitNarrowingExplicitExplicitExplicit(SalSqlHandle to SalWindowHandle) |
Automatic casting from SalSqlHandle to SalWindowHandle.
|
| ExplicitNarrowingExplicitExplicitExplicit(SalWindowHandle to SalSqlHandle) |
Automatic casting from int to SalSqlHandle.
|
| ImplicitWideningImplicitImplicitImplicit(SalSqlHandle to Boolean) |
Automatic casting from SalSqlHandle to boolean
|
| ImplicitWideningImplicitImplicitImplicit(SalSqlHandle to SalBoolean) |
Automatic casting from SalSqlHandle to SalBoolean
|
| Inequality(SalSqlHandle, SalWindowHandle) |
!= operator for comparing a SalSqlHandle to a SalWindowHandle
|
| Inequality(SalSqlHandle, SalSqlHandle) |
!= operator for comparing two SalSqlHandle objects
|
| Inequality(SalWindowHandle, SalSqlHandle) |
!= operator for comparing a SalSqlHandle to a SalWindowHandle
|
| LogicalNot |
! boolean NOT operator
|
Fields
| Name | Description | |
|---|---|---|
 | Null |
Properties
| Name | Description | |
|---|---|---|
 | Command |
Returns the inner prepared command object.
|
| Connection |
Returns the inner connection object.
|
| DataReader |
Returns the underlying IDataReader object.
It's null if ResultSet is on, use DataSet instead.
|
| DataSet |
Returns the underlying DataSet object.
It's null if ResultSet is off, use DataReader instead.
|
| Handle |
Returns the handle for this SalSqlHandle object
|
| IsNull |
Checks if this SalSqlHandle object contains a null db connection.
|
| LastError |
Returns the last error occurred.
|
| LastErrorCode |
Returns the last error code.
|
| LastErrorMessage |
Returns the last error message.
|
| LastErrorPosition |
Returns the last error position.
|
| LastStatement |
Returns the last sql statement executed on this handle.
|
| Properties |
Returns the properties associated with the connection.
|
| Transaction |
Returns the current open transaction.
|
