|
void setParamDirType(
SAParamDirType_t eParamDirType );
Sets parameter's direction type (input, output, etc.).
Parameters
eParamDirType . Defines parameter's
direction type. Can be one of the following SAParamDirType_t
enum values:
- SA_ParamInput Input
parameter.
- SA_ParamInputOutput
Input/output parameter.
- SA_ParamOutput Output
parameter.
- SA_ParamReturn Returning
parameter.
Remarks
Usually you should not define parameter's direction type by
yourself. The Library automatically detects parameter's direction type
and implicitly creates an appropriate SAParam object.
But not all of DBMS clients/servers provide complete parameters
information. In that situation programmer need to describe parameter's
direction type explicitly. See Server specific notes
for details.
Server specific notes
|
DBMS client
|
Specific information
|
|
Oracle
|
No need to call this method explicitly.
|
|
SQL Server
|
No need to call this method explicitly.
|
|
Sybase
|
Sybase ASE server does not provide
information about parameter's direction type, that's why SQLAPI++
Library defines all parameters (except status result code) as input
(SA_ParamInput). If you have input-output parameters in the procedure
you have to call SAParam::setParamDirType method for
these parameters before command execution and set parameter's direction
type explicitly.
You shouldn't call this method for procedure status result code because
it is detected correctly (as SA_ParamReturn) by the Library.
There is no need to call this method for Sybase
ASA because all parameters are detected correctly
automatically (including the direction type).
|
|
DB2
|
No need to call this method explicitly.
|
|
Informix
|
No need to call this method explicitly.
|
|
InterBase
|
No need to call this method explicitly.
|
|
SQLBase
|
No need to call this method explicitly.
|
|
MySQL
|
No need to call this method explicitly.
|
|
PostgreSQL
|
No need to call this method explicitly.
|
|
ODBC
|
No need to call this method explicitly.
|
See also
ParamDirType
SAParamDirType_t enum
Problems and Questions
If you haven't found the answer to your questions or have
some problems on using the Library, please, send e-mail to howto@sqlapi.com.
|