<<

Contents

Search

>>

 

JDBC_FETCH

 

 

Function

 

 

Syntax:

JDBC_FETCH(<File Number>)

 

<File Number> = <NUM-EXPRESSION>

 

Meaning:

Fetches the next data row from the result table and fills all JDBC_JOIN variables.

 

JDBC_FETCH returns the result –1 if an error occurred, otherwise 0.

 

If an error occurs, the variable OK contains the error number and the function JDBC_GET_LAST_ERROR$ returns the error text.

 

Parameter:

File Number

Number of JDBC database

 

Sample:

H% = JDBC_FETCH(2)

IF H% = -1

THEN ERRORMES = JDBC_GET_LAST_ERROR$

ENDIF

 

See also:

JDBC_EXTFETCH

JDBC_EXEC_DIRECT

JDBC_EXEC_PREPARED

JDBC_JOIN