JDBC_MULTIWRITE
|
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:
|
||||||||||||||
|
Parameter: |
|
||||||||||||||
|
Sample: |
H% = JDBC_MULTIWRITE(CUSTOMER) IF H% = -1 THEN ERRORMES = "Error with MULTIWRITE: " + STR$(H%) ENDIF |
||||||||||||||
|
See also: |
|