SQLxxx functions

The following functions are available:

  • Getting a value via a "select" instruction on a table column
  • Getting data returned by a procedure
  • Getting a value via a "select" full instruction
  • Checking that a value exists via a "select" instruction

For information on return values, refer to Return values.

Get a value via a "select" instruction on a table column (SQLSELECT)

Name Data Type Input / Output Description

szCol

char

I

Name of the column in which the search is made

szTable

char

I

Name of the table in which the search is made

szCondWhere

char

I

Search condition associated with the select instruction

szZoneRetour

char

O

Result of the query (first value found)

szCodeRet

char

O

Function return code

Get data returned by a procedure (SQLPROC)

Name Data Type Input / Output Description

szProc

char

I

Instruction calling the procedure

szParamIn

char

I

Value of the procedure input parameter

szParamOut

char

O

Value of the procedure output parameter

szCodeRet

char

O

Function return code

szCodeRetProc

char

O

Procedure return code

Get a value via a "select" full instruction (SQLDIRECTSELECT)

Name Data Type Input / Output Description

szSelect

char

I

Query submitted

szZoneRetour

char

O

Result of the query (first value found)

szCodeRet

char

O

Function return code

Check that a value exists via a "select" instruction (SQLDIRECTSELECT)

Name Data Type Input / Output Description

szSelect

char

I

Query activated

szValue

char

I

Value of the data to be checked by the query

szCodeRet

char

O

Function return code

Return values

The return values for the SQLxxx functions are:

  • 0: ONE_ROW
    • PROC_OK for the queries
    • RET_PLSQL_OK for the procedure)
  • 1: NO_ROW
  • 2: FEW_ROW
  • 9: ERROR_SQL

Related Links