Home How To Online Documentation Support Download Order

 

 

 

SACommand
SAConnection
SAException
SAField
SAParam

SAString
SADateTime
SANumeric
SAInterval

Enums and Typedefs

  

Usage

Class Members

Examples

SAParam::setParamDirType

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.