Description:
Delete specified records from a table sequence.
Syntax:
|
T.delete(k) |
Delete the kth record |
|
T.delete(p) |
Delete records whose ordinal numbers exist in p |
|
T.delete(A) |
Delete records that exist in sequence A |
Note:
The function deletes the specified records from table sequence T, and automatically updates the index, if any, and checks distinctness. The deleted records will be always saved in the delete buffer.
Parameter:
|
T |
A table sequence |
|
k |
A positive integer, which specifies the position of a record to be deleted |
|
p |
An integer sequence with the length of n, which specifies the positions of the records to be deleted |
|
A |
A sequence, which specifies the records to be deleted |
Option:
|
@n |
Return the deleted record or a record sequence of the deleted records |
Return value:
Table sequence
Example:
|
|
A |
|
|
|
1 |
=demo.query("select * from EMPLOYEE") |
|
|
|
2 |
=A1.delete(1) |
Delete the first record. |
|
|
3 |
=A1.delete([2,4,6]) |
Delete the second, the fourth and the sixth records. |
|
|
4 |
=A1.select(EID>5) |
|
|
|
5 |
=A1.delete(A4) |
Delete the records whose EID is more than 5. |
|
|
6 |
=A1.delete@n(1) |
Return the deleted record. |
|
Note:
We use the store address, instead of the field names or field values, to judge whether the records specified by A exist in T. So to delete the specified records, we generally use the function T.delete(T.select(…)) to locate them.
Related function: