<<

Contents

Search

>>

 

DELETE

 

 

Instruction

 

 

Syntax:

DELETE <Name of Index File> ON ERROR ... END

 

<Name of Index File> =<INDEX FILE>

 

Meaning:

Deletes that sentence of the Index File that is specified by the current primary key.

 

In the case of an error the block ON ERROR ... END is executed. The variables OK and OK2 then contain the error number and ERRORTEXT$ contains the error text.

 

Note: In a multi-user operation the data record must have been read with a READ instruction (READ, READS, START, STARTS, READ-PREVIOUS, READ-NEXT, READS-PREVIOUS, READS-NEXT), so that the current record is locked. If one tries to delete an unlocked record, the error 1062 is reported.

Parameter:

Name of Index File

Name of Index File

 

Sample:

DELETE CUSTOMER ON ERROR ERRORMES = "Error deleting CUSTOMER:" +

                                    STR$(OK) + STR$(OK2)+ " " + ERRORTEXT$

                END

 

See also:

READ

READS

START

STARTS

READ-PREVIOUS

READ-NEXT

READS-PREVIOUS

READS-NEXT

WRITE

OK

OK2

ERRORTEXT$

JDBC_DROP_TABLE

KILL_INDEXFILE