The Sql type exposes the following members.
Methods
Name | Description | |
---|---|---|
ClearImmediate |
Disconnects the internal Sql Handle from a database.
| |
Close | Obsolete.
Not supported.
| |
CloseAllSPResultSets |
Closes any result sets generated by the execution of a stored procedure.
| |
CloseResultSet |
Close the current result set.
| |
Commit(SalSqlHandle) |
Commits all of the SQL transaction's cursors that are connected to the same database.
| |
Commit(SalSqlHandle, WhenSqlErrorHandler) |
Commits all of the SQL transaction's cursors that are connected to the same database.
| |
CommitSession(SalSqlSessionHandle) |
Commits the current transaction associated with the specified session.
| |
CommitSession(SalSqlSessionHandle, WhenSqlErrorHandler) |
Commits the current transaction associated with the specified session.
| |
Connect(SalSqlHandle%) |
Connects to a database.
| |
Connect(SalSqlHandle%, WhenSqlErrorHandler) |
Connects to a database.
| |
ConnectImmediate |
Connects the internal Sql Handle used for SqlImmediate calls.
| |
ConnectTransaction | Obsolete.
Not supported.
| |
ConnectUsingCursor | Obsolete.
Not supported.
| |
ContextClear |
Clears the sql context.
| |
ContextSet |
Sets the sql context to the current form.
| |
ContextSetToForm |
Sets the contetx to the specified form.
| |
CreateSession(SalSqlSessionHandle%, SalString) |
Creates a new session.
| |
CreateSession(SalSqlSessionHandle%, SalString, WhenSqlErrorHandler) |
Creates a new session.
| |
CreateStatement |
Creates a new statement belonging to the specified session.
| |
DirectoryByName |
Returns the database names on the specified server.
| |
Disconnect |
Disconnects from a database.
| |
DisconnectWithoutCursor | Obsolete.
Not supported.
| |
DropStoredCmd | Obsolete.
Not supported.
| |
Error |
Returns the most recent error code for the specified Sql Handle.
| |
ErrorText |
Returns the error text corresponding to the error number.
| |
Execute(SalSqlHandle) |
Executes a SQL statement that was previously prepared.
| |
Execute(SalSqlHandle, WhenSqlErrorHandler) |
Executes a SQL statement that was previously prepared.
| |
ExecutionPlan | Obsolete.
Not supported.
| |
Exists(SalString, SalBoolean%) |
Determines whether a row exists.
| |
Exists(SalString, SalBoolean%, WhenSqlErrorHandler) |
Determines whether a row exists.
| |
ExtractArgs | ||
FetchNext(SalSqlHandle, SalNumber%) |
Fetches the next row in a result set.
| |
FetchNext(SalSqlHandle, SalNumber%, WhenSqlErrorHandler) |
Fetches the next row in a result set.
| |
FetchPrevious(SalSqlHandle, SalNumber%) |
Fetches the previous row in a result set.
| |
FetchPrevious(SalSqlHandle, SalNumber%, WhenSqlErrorHandler) |
Fetches the previous row in a result set.
| |
FetchRow(SalSqlHandle, SalNumber, SalNumber%) |
Fetches a row according at the absolute row position.
| |
FetchRow(SalSqlHandle, SalNumber, SalNumber%, WhenSqlErrorHandler) |
Fetches a row according at the absolute row position.
| |
FreeSession(SalSqlSessionHandle%) |
Frees the session.
| |
FreeSession(SalSqlSessionHandle%, WhenSqlErrorHandler) |
Frees the session.
| |
GetCmdOrRowsetPtr | Obsolete.
Not supported.
| |
GetCursor | Obsolete.
Not supported.
| |
GetDSOrSessionPtr | Obsolete.
Not supported.
| |
GetError |
Returns the last error information.
| |
GetErrorPosition |
Returns the offset of the error position within the last SQL statement.
| |
GetErrorText |
Returns the error text corresponding to the error number.
| |
GetErrorTextX |
Returns the error text corresponding to the error number.
| |
GetLastStatement |
Returns the last SQL statement.
| |
GetModifiedRows |
Returns the number of rows affected by the most recent INSERT, UPDATE, or DELETE
statement.
| |
GetNextSPResultSet |
Returns the next result set returned by a stored procedure.
| |
GetParameter |
Gets the value of a database parameter.
| |
GetParameterAll | Obsolete.
Not supported.
| |
GetResultSetCount(SalSqlHandle, SalNumber%) |
Returns the number of rows in the result set.
| |
GetResultSetCount(SalSqlHandle, SalNumber%, WhenSqlErrorHandler) |
Returns the number of rows in the result set.
| |
GetRollbackFlag | Obsolete.
Not supported.
| |
GetSessionErrorInfo |
Returns the error information associated with the specified session.
| |
GetSessionHandle |
Returns the session handle to which the specified statement handle belongs.
| |
GetSessionParameter |
Gets the value of the specified session property.
| |
GetSqlHandle | Obsolete.
Not supported.
| |
GetStatementErrorInfo |
Returns the error information associated with the specified statement handle.
| |
Immediate(SalString) |
Prepares and executes a SQL statement.
| |
Immediate(SalString, WhenSqlErrorHandler) |
Prepares and executes a SQL statement.
| |
ImmediateContext |
Prepares and executes a SQL statement using a different sql context.
| |
Open | Obsolete.
Not supported.
| |
OraPLSQLCommand(SalSqlHandle, SalString) |
Executes an Oracle PL/SQL stored procedure. Supports dynamic arrays and recive
array parameters.
| |
OraPLSQLCommand(SalSqlHandle, SalString, WhenSqlErrorHandler) |
Executes an Oracle PL/SQL stored procedure. Supports dynamic arrays and recive
array parameters.
| |
OraPLSQLExecute(SalSqlHandle) |
Executes the anonymous PL/SQL block that was prepared
using SqlOraPLSQLPrepare.
| |
OraPLSQLExecute(SalSqlHandle, WhenSqlErrorHandler) |
Executes the anonymous PL/SQL block that was prepared
using SqlOraPLSQLPrepare.
| |
OraPLSQLPrepare(SalSqlHandle, SalString) |
Compiles the anonymous PL/SQL block.
| |
OraPLSQLPrepare(SalSqlHandle, SalString, WhenSqlErrorHandler) |
Compiles the anonymous PL/SQL block.
| |
OraPLSQLStringBindType | Obsolete.
Not supported.
| |
Prepare(SalSqlHandle, SalString) |
Compiles a SQL statement for execution.
| |
Prepare(SalSqlHandle, SalString, WhenSqlErrorHandler) |
Compiles a SQL statement for execution.
| |
PrepareAndExecute(SalSqlHandle, SalString) |
Compiles and executes a SQL statement.
| |
PrepareAndExecute(SalSqlHandle, SalString, WhenSqlErrorHandler) |
Compiles and executes a SQL statement.
| |
PrepareSP(SalSqlHandle, SalString, SalString) |
Prepares a stored procedure invokation statement.
| |
PrepareSP(SalSqlHandle, SalString, SalString, WhenSqlErrorHandler) |
Prepares a stored procedure invokation statement.
| |
Retrieve(SalSqlHandle, SalString, SalString, SalString) |
Retrieves a SQLBase compiled command.
| |
Retrieve(SalSqlHandle, SalString, SalString, SalString, WhenSqlErrorHandler) |
Retrieves a SQLBase compiled command.
| |
Rollback(SalSqlHandle) |
Rolls back all of the SQL transaction's cursors that are connected to the same database.
| |
Rollback(SalSqlHandle, WhenSqlErrorHandler) |
Rolls back all of the SQL transaction's cursors that are connected to the same database.
| |
RollbackSession(SalSqlSessionHandle) |
Rolls back the current transaction associated with the specified session.
| |
RollbackSession(SalSqlSessionHandle, WhenSqlErrorHandler) |
Rolls back the current transaction associated with the specified session.
| |
SetInMessage | Obsolete.
Not supported.
| |
SetIsolationLevel |
Sets the isolation level.
| |
SetLockTimeout |
Specifies the maximum time to wait before generating an error.
| |
SetLongBindDatatype | Obsolete.
Not supported.
| |
SetOutMessage | Obsolete.
Not supported.
| |
SetParameter |
Sets the value of a database parameter.
| |
SetParameterAll | Obsolete.
Not supported.
| |
SetResultSet |
Turns result set mode on or off for all handles associated with the same connection.
| |
SetSessionParameter |
Sets the value of the specified session property.
| |
Store | Obsolete.
Not supported.
| |
VarSetup(SalSqlHandle) |
Saves the sql bind variables context using the SalCompileAndEvaluate context.
| |
VarSetup(SalSqlHandle, Object) |
Saves the sql bind variables context.
| |
XDirectory | Obsolete.
Not supported.
|