T. modify()

T.modify(k,xi:Fi,…)

Modify the k^th record, which is equal to T(k).modify(x_i:F_i,…) .

T.modify(k:A,xi:Fi,…)

Modify the records from the k^th record to the (k+|A|-1)^th record.

k

The position at which the record will be modified. If k exceeds the limit, then append a new record in the end.

xi

The value of Fi field to be modified.

Fi

Name of the field of the record which will be modified. If Fi is omitted, then modify the i^th field of T.

T

A table sequence.

A

A sequence or an integer; If A is an integer, then it is equal to to(A) .

@n

Return the newly-modified record or sequence.

@r(k:A)

Modify table sequence T using sequence A from the k^th record according to the order of the fields.

@f(k:A)

Modify table sequence T using sequence A from the k^th record; only the common fields are modified.

A

1

=demo.query("select * from DEPARTMENT")

2

=A1.modify(1,"Sales",5)

Modify the first and the second fields of the first record.

3

=A1.modify(2,6:MANAGER)

Modify the MANAGER field of the second record.

4

=A1.modify@n(2:1,"AAA":DEPT,76:MANAGER)

Return the modified second record.

5

=create(DeptName,ManagerID)

6

=A5.modify(1:A1,DEPT:DeptName,MANAGER:ManagerID)

Append a new record in the end because 1 exceeds the limit.

7

=A1.delete(A1.select(MANAGER>5))

8

=A5.modify@r(1:A7)

Modify A5 using A7 from the first record.

9

=create(DeptName,MANAGER)

10

=A9.modify@f(1:A7)

Modify MANAGER field only.