JDBC_WRITE_MODE
|
Syntax: |
JDBC_WRITE_MODE(<Name of Index
File>,<Mode>)
|
||||||||||
|
|
|
||||||||||
|
Meaning: |
If
a data records of a JDBC index file is saved with the WRITE
instruction, a program-internal SQL check must be carried out first in order
to check if the data record already exists. This takes additional computing
time. If
<Mode> is set to 1 for a JDBC index file, the program-internal SQL
check is not carried out. This increases speed significantly when new data
records are written into an SQL database.
Note: <Mode> may only be
set to 1 as long as new data records are written. If a data record already exists, the program
reports an error.
JDBC_WRITE_MODE
returns the following results:
|
||||||||||
|
Parameter: |
|
||||||||||
|
Sample: |
H% = JDBC_WRITE_MODE(CUSTOMER,1) IF H% <> 1 THEN ERRORMES = "Error with JDBC_WRITE_MODE: " + STR$(H%) ENDIF |
||||||||||
|
See also: |
|