This chapter lists code examples of handling data maintenance in table sequences and record sequences, including Copy a table sequence entirely, Insert one or multiple null or non-null records into a table sequence, Remove one or multiple records from a table sequence, Modify field values of one or multiple records, Modify the record at a specified position and fill up the position automatically if it is beyond range, Add a calculated column to a table sequence, Create a new table sequence based on the specified table sequence/record sequence, Combine table sequences or split a table sequence, Insert a sequence into the newly-created table sequence to generate new records, Get field values of a table sequence/record sequence and join them into a sequence, Add sequence members into a table sequence/record sequence as field values, Add sequence members to a table sequence/record sequence vertivally as field values, Copy field values of a table sequence/record sequence into another table sequence/record sequence, and Modify values of specified field.
|
|
A |
|
|
1 |
=demo.query("select NAME,EVENT, SCORE from GYMSCORE") |
|
|
2 |
=A1.derive() |
Copy the table sequence entirely |
|
3 |
=A1.to(,) |
Copy as a record sequence only |
|
|
A |
|
|
1 |
=create(ID,NAME,AGE) |
Create an empty table sequence |
|
2 |
>A1.insert(0,10,"Lucy",20) |
Insert a record at the end |
|
3 |
>A1.insert(1,1,"Jim",19) |
Insert a record at the first row |
|
4 |
>A1.insert(2:8,#+1,"Name"+string(#+1),rand(4)+18) |
Insert eight records starting from the second row |
|
5 |
=create(id,NAME,Age) |
Create an empty table sequence |
|
6 |
>A5.insert(0:5,#+10,"Name"+string(#+10),rand(4)+18) |
Insert 5 records at the end |
|
7 |
=A1.insert@r(0:A5) |
Insert A5’s records to A1 |
|
8 |
=A1.insert@f(0:A5) |
Insert namesake fields in A5 to A1 |
|
9 |
>A1.insert(2) |
Insert an empty record before the second row |
|
10 |
>A1.insert(0:10,~:ID) |
Append 10 records at the end and set ID field values |
|
|
A |
|
|
1 |
=demo.query("select NAME, EVENT, SCORE from GYMSCORE") |
|
|
2 |
>A1.delete(2) |
Remove the second record |
|
3 |
>A1.delete([4,6,1]) |
Remove multiple records |
|
4 |
>A1.delete(A1.select(SCORE<15)) |
Remove records based on specified conditions |
|
|
A |
|
|
1 |
=demo.query("select NAME,EVENT, SCORE from GYMSCORE") |
|
|
2 |
>A1.run(SCORE+2:SCORE) |
Modify all the records |
|
3 |
>A1.select(EVENT=="Vault").run(SCORE+2:SCORE) |
Modify some of the records |
|
|
A |
|
|
1 |
=demo.query("select NAME,EVENT, SCORE from GYMSCORE") |
A table sequence |
|
2 |
=A1.modify(5,"":EVENT,15:SCORE) |
Modify the fifth record and fill up the out-of-range positions automatically |
|
|
A |
|
|
1 |
=demo.query("select NAME,UNITPRICE, QUANTITY from RECEIPT") |
|
|
2 |
=A1.derive(UNITPRICE*QUANTITY:Amount) |
Add the "Amount" field |
|
|
A |
|
|
1 |
=demo.query("select NAME, ABBR, CAPITAL,POPULATION from STATES") |
|
|
2 |
=A1.new(NAME, ABBR) |
Create a new table sequence based on the original one |
|
3 |
=A1.new(NAME:State, ABBR,CAPITAL:Capital) |
Change the field names |
|
|
A |
|
|
1 |
=demo.query("select * from STUDENTS1") |
|
|
2 |
=demo.query("select * from STUDENTS2 ") |
|
|
3 |
=A1|A2 |
Concatenate table sequences A1 and A2 |
|
|
A |
B |
|
|
1 |
1 |
Tom |
|
|
2 |
2 |
Jack |
|
|
3 |
3 |
Andy |
|
|
4 |
=create(id,name) |
|
|
|
5 |
=A4.record([A1:B3]) |
|
|
|
|
A |
B |
|
|
1 |
1 |
Tom |
|
|
2 |
2 |
Jack |
|
|
3 |
3 |
Andy |
|
|
4 |
=create(id,name) |
|
|
|
5 |
=A4.record([A1:B3]) |
|
|
|
6 |
=A5.field(2) |
|
Return the same sequence as [B1:B3] |
|
|
A |
B |
|
|
1 |
1 |
Tom |
|
|
2 |
2 |
Jack |
|
|
3 |
3 |
Andy |
|
|
4 |
=create(id, name).insert(1:3) |
|
|
|
5 |
=A4.paste@a([A1:B3]) |
|
|
|
|
A |
B |
C |
|
|
1 |
1 |
2 |
3 |
|
|
2 |
Tom |
Jack |
Andy |
|
|
3 |
=create(id, name).insert(1:3) |
|
|
|
|
4 |
=A3.modify(1:[A1:C1],~:#1) |
|
|
The first column |
|
5 |
=A3.modify(1:[A2:C2],~:#2) |
|
|
The second column |
|
|
A |
|
|
1 |
=create(name,price) |
|
|
2 |
=demo.query("select NAME,UNITPRICE, QUANTITY from RECEIPT") |
|
|
3 |
=A1.modify@r(0:A2) |
|
|
|
A |
|
|
1 |
=demo.query("select * from EMPLOYEE") |
|
|
2 |
=A1.field("SALARY",[8000,9000]) |
Modify the first two values of SALARY field |
|
3 |
=A1.field(9,[8000,9000]) |
Modify the first two values of the 9th field |