INSERT action


Function
The action inserts one or several rows into specified structure.
Declaration
 INSERT _struct, beforeIdx, rowsToInsert
[, lastRow]
Parameters
struct in/out Whole structure identifier where the row will be inserted to.
beforeIdx in Identifier of Int type. Inserted row will be inserted before the row specified in this parameter.
rowsToInsert in Whole structure identifier or one row identifier - row(s) to insert.
lastRow in Optional parameter - one row identifier.

Description
The action inserts:
  • row, if rowsToInsert is the reference to an structure row, or
  • rows (whole structure) if rowsToInsert is the reference to a whole structure

Inserting will be performed into the local structure _struct before the row given by the parameter _beforeIdx. If _beforeIdx = _struct\DIM+1 or _beforeIdx = -1, the action will insert the given row(s) in the end of the structure (append). If the value of the parameter  _beforeIdx different, the action ill generates the error _ERR_RANGE_ERROR. The structures _struct and rowsToInsert must be the same type.

If the parameter lastRow is used, the action will copy the source structure rows determined by the parameters rowsToInsert and lastRow. In this case both the parameters must represent a row of the same structure.


Example:
RECORD (SD.RecordDef) _struct
 RECORD  (SD.RecordDef) _rowsToInsert
 INT _beforeIdx
 
 REDIM _struct[10]
 REDIM _rowsToInsert[2]
 
 ; inserting 1st row in the beginning
 INSERT _struct, 1, _rowsToInsert[1]
 
 ; inserting 2nd row at the end
 _beforeIdx := _struct\DIM+1
 INSERT _struct, _beforeIdx , _rowsToInsert[2]
 
 ; inserting the whole structure rowsToInsert in the beginning
 INSERT _struct, 1 , _rowsToInsert

Example 2
Inserting the 1st and 2nd rows of the structure _rowsToInsert at the beginning of the structure _struct.
 
 
INSERT _struct, 1, _rowsToInsert[1], _rowsToInsert[2]


Related pages:

0 komentárov

Nie ste prihlásený. Akékoľvek zmeny, ktoré vykonáte, sa označia ako anonymné. Ak už máte svoj účet, pravdepodobne sa budete chcieť prihlásiť .