JDBC_JOIN
|
Syntax: |
JDBC_JOIN(<File Number>,<Number of
Column>,<String Variable>)
|
||||||
|
|
|
||||||
|
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: |
|
||||||
|
Sample: |
H% = JDBC_JOIN(2,10,NAME$) IF H% = -1 THEN ERRORMES
= JDBC_GET_LAST_ERROR$ ENDIF |
||||||
|
See also: |
|