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.
|
Fields
| Name | Description | |
|---|---|---|
 | Database |
This string variable contains the name of the database to which the application connects.
|
| IsolationLevel |
This system variable sets the isolation level for the next connection to a database server.
The isolation level controls the effect that changes made by one user have on another user accessing the same tables.
Valid strings are:
- Read Repeatability (RR)
- Cursor Stability (CS)
- Release Locks (RL)
|
| Password |
This string variable contains a password necessary to access a database.
The default password is SYSADM.
|
| ResultSet |
Result set status flag.
|
| ResultSetMode |
Behavior for when the ResultSet mode is on.
|
| UniversalDataLink |
SqlUDL is a system variable that can contain a provider name or the name of a UDL file
to use for OLE DB connection information.
|
| User |
This string variable contains a user name necessary to access a database.
The default authorization name is SYSADM.
|
