<<

Contents

Search

>>

 

JDBC_MULTIWRITE

 

 

Function

 

 

Syntax:

JDBC_MULTIWRITE(<Name of Index File>)

 

<Name of Index File> = <INDEX FILE>

 

 

Meaning:

With Index Files of type JDBC WRITE instructions take considerable computing time, because each WRITE instruction requires a separate SQL instruction to be executed. 

 

If the variable EBUS_JDBC_MULTIWRITE is set to 1, those WRITE instructions which create new data records are not executed, but the data records are cached program-internally.

 

The function JDBC_MULTIWRITE writes all stored data records with one single SQL instruction into the SQL database and deletes the cached data records in the memory buffer.

 

JDBC_MULTIWRITE returns the following results:

   

Result

Meaning

1

No error

-1

Error: OK, OK2 and ERRORTEXT$ contain the error text.

-2

A runtime error occurred. 

-3

<Name of Index File> is no JDBC Index File.

-4

There are no cached data records available.

-5

<Name of Index File> is invalid.

 

Parameter:

Name of Index File

Name of Index File

 

Sample:

H% = JDBC_MULTIWRITE(CUSTOMER)

IF H% = -1

THEN ERRORMES = "Error with MULTIWRITE: " + STR$(H%)

ENDIF

 

See also:

EBUS_JDBC_MULTIWRITE

JDBC_WRITE_MODE

WRITE