<<

Contents

Search

>>

 

JDBC_EXEC_DIRECT

 

 

Function

 

 

Syntax:

JDBC_EXEC_DIRECT(<File Number>,<Command>)

 

<File Number>

= <NUM-EXPRESSION>

<Command>

= <STRING-EXPRESSION>

 

 

Meaning:

Executes the SQL command <Command>.

 

JDBC_EXEC_DIRECT 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

Command

SQL command

 

Sample:

H% = JDBC_EXEC_DIRECT(3,"Select * from Customer")

IF H% = -1

THEN ERRORMES = JDBC_GET_LAST_ERROR$

ENDIF

 

See also:

JDBC_CONNECT

JDBC_EXEC_PREPARED

JDBC_SETPARAM

JDBC_PREPARE