Home How To Online Documentation Support Download Order

 

 

 

SACommand
SAConnection
SAException
SAField
SAParam

SAString
SADateTime
SANumeric
SAInterval

Enums and Typedefs


Usage

Examples

SACommand

Construction / Destruction

SACommand Constructs a SACommand object
~SACommand Destructs a SACommand object

Methods

Connection Returns a pointer to the current SAConnection object
setConnection Associates a command with an existing SAConnection object

Open Opens a command
isOpened Tests whether a command is opened
Close Closes a command
Destroy
Destroys a broken command
Reset Clears all DBMS related handles and sturctures but doesn't destroy them (mostly for Unix fork/exec based applications)

setCommandText Sets command text
CommandText Returns a command text
CommandType Returns a command type
Prepare Prepares command before execution
Execute Executes command
isResultSet Tests whether a result set exists after the last command execution
RowsAffected Returns number of rows affected by the last command execution
FetchNext Fetches next row from a result set
FetchPrior Fetches previous row from a result set
FetchFirst Fetches the first row from a result set
FetchLast Fetches the last row from a result set
Cancel Attempts to cancel the pending result set, or current statement execution

CreateParam Creates parameter 
DestroyParams Destroys all parameters associated with the SACommand object
ParamCount Returns the number of bind variables for SQL statement or stored procedure specified in the SACommand object
ParamByIndex Returns the SAParam object by index in params array
Param Returns the SAParam object by name or position specified in SQL statement
operator << Binds input parameters

FieldCount Returns the number of columns in result set
Field Gets specified SAField object by its name or position
operator [] Gets specified SAField object by its name or position - operator substitution for Field

setOption Sets a string value of a specific command option
Option Gets a string value of a specific command option

NativeHandles Gets native DBMS client command related handle(s)