<<

Contents

Search

>>

 

JDBC_WRITE_MODE

 

 

Function

 

 

Syntax:

JDBC_WRITE_MODE(<Name of Index File>,<Mode>)

 

<Name of Index File>

= <INDEXFILE>

<Mode>

= <NUM-EXPRESSION>

 

 

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:

  

Result

Meaning

1

No error

-2

A runtime error occurred. 

-3

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

-5

<Name of Index File> is invalid.

 

Parameter:

Name of Index File

Name of Index File

Mode

Mode

 

Sample:

H% = JDBC_WRITE_MODE(CUSTOMER,1)

IF H% <> 1

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

ENDIF

 

See also:

EBUS_JDBC_MULTIWRITE

JDBC_MULTIWRITE

WRITE