SQLAPI++ Library - Online Documentation

SACommand

SAConnection

SAException

SAField

SAString

SANumeric

Usage	Examples
SAParam

Methods

Name	Returns name of the parameter
ParamType	Returns parameter's data type
setParamType	Sets parameter's data type
ParamSize	Returns parameter's data size
setParamSize	Sets parameter's data size
ParamPrecision	Returns parameter's precision
setParamPrecision	Sets parameter's precision
ParamScale	Returns parameter's scale
setParamScale	Sets parameter's scale
ParamNativeType	Returns code of parameter's native data type
setParamNativeType	Sets parameter's native data type type
ParamDirType	Returns direction type of parameter (input, output, etc.)
setParamDirType	Sets direction type of parameter (input, output, etc.)

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

ReadLongOrLob	Starts reading of Long or BLob(CLob) value using user defined callback

Base Class Members (defined in SAValue)

setAsNull	Sets parameter's value as null
setAsDefault	Forces to use the default parameter's value
isDefault	Shows if parameter uses the default value
setAsUnknown	Sets parameter's type as unknown
setAsBool	Sets parameter's value as bool data
setAsShort	Sets parameter's value as short data
setAsUShort	Sets parameter's value as unsigned short data
setAsLong	Sets parameter's value as long data
setAsULong	Sets parameter's value as unsigned long data
setAsDouble	Sets parameter's value as double data
setAsNumeric	Sets parameter's value as SANumeric data
setAsDateTime	Sets parameter's value as SADateTime data
setAsString	Sets parameter's value as character string data (SAString)
setAsBytes	Sets parameter's value as binary string data (SAString)
setAsLongBinary	Sets parameter's value as long binary data (SAString)
setAsLongChar	Sets parameter's value as long character data (SAString)
setAsBLob	Sets parameter's value as BLob data (SAString)
setAsCLob	Sets parameter's value as CLob data (SAString)
setAsCursor	Sets parameter's value as a pointer to SACommand object
setAsValueRead	Sets parameter's value from SAParam or SAField objects

Base Class Members (defined in SAValueRead)

DataType	Returns parameter's value data type
isNull	Shows if parameter's value is null
asBool	Returns parameter's value as bool data; converts if needed
asShort	Returns parameter's value as short data; converts if needed
asUShort	Returns parameter's value as unsigned short data; converts if needed
asLong	Returns parameter's value as long data; converts if needed
asULong	Returns parameter's value as unsigned long data; converts if needed
asDouble	Returns parameter's value as double data; converts if needed
asNumeric	Returns parameter's value as SANumeric data; converts if needed
asDateTime	Returns parameter's value as SADateTime data; converts if needed
asString	Returns parameter's value as string data (SAString); converts if needed
asBytes	Returns parameter's value as binary string data (SAString); converts if needed
asLongBinary	Returns parameter's value as long binary data (SAString); converts if needed
asLongChar	Returns parameter's value as long character data (SAString); converts if needed
asBLob	Returns parameter's value as BLob data (SAString); converts if needed
asCLob	Returns parameter's value as CLob data (SAString); converts if needed
asCursor	Returns parameter's value as a pointer to SACommand object
setLongOrLobReaderMode	Sets Long or Lob data reading mode
LongOrLobReaderMode	Gets Long or Lob data reading mode
operator bool()	Substitute asBool method to provide quick access for parameter's value. Returns parameter's value as bool data; converts if needed
operator short()	Substitute asShort method to provide quick access for parameter's value. Returns parameter's value as short data; converts if needed
operator unsigned short()	Substitute asUShort method to provide quick access for parameter's value. Returns parameter's value as unsigned short data; converts if needed
operator long()	Substitute asLong method to provide quick access for parameter's value. Returns parameter's value as long data; converts if needed
operator unsigned long()	Substitute asULong method to provide quick access for parameter's value. Returns parameter's value as unsigned long data; converts if needed
operator double()	Substitute asDouble method to provide quick access for parameter's value. Returns parameter's value as double data; converts if needed
operator SANumeric()	Substitute asNumeric method to provide quick access for parameter's value. Returns parameter's value as SANumeric data; converts if needed
operator SADateTime()	Substitute asDateTime method to provide quick access for parameter's value. Returns parameter's value as SADateTime data; converts if needed
operator SAString()	Substitute asString method to provide quick access for parameter's value. Returns parameter's value as string data (SAString); converts if needed
operator SACommand *()	Substitute asCursor method to provide quick access for parameter's value. Returns parameter's value as a pointer to SACommand object

Usage

Examples

SAParam

Methods

Base Class Members (defined in SAValue)

Base Class Members (defined in SAValueRead)