<<

Contents

Search

>>

 

JDBC_JOIN

 

 

Function

 

 

Syntax:

JDBC_JOIN(<File Number>,<Number of Column>,<String Variable>)

 

<File Number>

= <NUM-EXPRESSION>

<Number of Column>

= <NUM-EXPRESSION>

<String Variable>

= <STRING-EXPRESSION>

 

 

Meaning:

Joins a column to a string variable.

 

With every JDBC_FETCH or JDBC_EXTFETCH this variable is automatically filled with the value from the respective table column.

 

Note: If a JDBC_JOIN is defined, the functions JDBC_GET_INT,  JDBC_GET_NUM and JDBC_GET_STRING$  can only access those fields whose column number is bigger than the biggest column number with JDBC_JOIN.

 

JDBC_JOIN 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

Number of Column

Number of column

String Variable

Name of string variable

 

Sample:

H% = JDBC_JOIN(2,10,NAME$)

IF H% = -1

THEN ERRORMES = JDBC_GET_LAST_ERROR$

ENDIF

 

See also:

JDBC_FETCH

JDBC_EXTFETCH