Modify Record
A
1 =demo.query("select EID, NAME+?+SURNAME as FULLNAME, GENDER, STATE, BIRTHDAY, SALARY from EMPLOYEE"," ")
2
>A1.insert(0,2000,"Julia Jones","F","Florida",date("1988-1-10"),10000)
3
>A1.insert(2,20,"M":GENDER,"Brandon Williams":FULLNAME,"California":STATE,"test")
4
>A1.delete(3)
5
>A1.delete([4,20,7])
6
>A1.modify(1,1,"Emily Lee","F","California",date("1984-4-2"),8000)
7
>A1.modify(2,8000:SALARY)
8
>A1(3).FULLNAME="Helen Brown"
9
>A1.delete(A1.pselect@a(SALARY>15000))

After modified, TSeq can be viewed in the A1: