Table Sequence Functions

Read(542) Label: table sequence function,

  Learn about table sequence functions that are unique in esProc and that handle table sequence values.

Ø  A.field(F)

Get the values in a specified field of a sequence

Ø  A.field(F,x)

Modify the value of a specified field in a sequence

Ø  P.run()

Compute the given expression for each record of the record sequence

Ø  T.create()

Generate an empty table sequence by duplicating the data structure of another table sequence

Ø  T.delete()

Delete specified records from a table sequence

Ø  T.fname()

Get names of fields of a table sequence

Ø  T.fno()

Get the serial number(s) of a single or multiple specified fields in a table sequence

Ø  T.index()

Create an index table for the key of a table sequence

Ø  T.insert()

Insert one or more records into a table sequence

Ø  T.keys()

Set a key for a table sequence

Ø  T.keys(Ki,…;n)

Create an index over a primary key when the latter is set

Ø  T.modify()

Modify one or more records of a table sequence

Ø  T.paste()

Loop through the records of a sequence to modify the specified field of a table sequence in order.

Ø  T.record()

Use the members of a sequence to form new records of a table sequence

Ø  T.reset()

Clear the members of a table sequence

Ø  T.rename()

Modify field names

Ø  T.select()

Return members of a table sequence/memory table which satisfy a condition

Ø  create()

Create an empty table sequence

Ø  create(#F)

Create an empty table sequence with one or more keys set

Ø  ifr()

Find whether an object is a record

Ø  ift()

Find whether an object is a table sequence

Ø  k.r(T.F)

Find a certain field of a specified row in a table sequence/memory table

Ø  r.F

Get value for field F of record r

Ø  r.F=x

Assign x to field F of record r

Ø  r.array()

Get the field values from a record respectively and return them as a sequence

Ø  r.create()

Create a table sequence by copying the data structure of a specified record

Ø  r.field(F)

Get the value of a certain field in a record

Ø  r.field(F,x)

Modify values in the specified field of a record

Ø  r.fname()

Get the name of a field of the record according to the serial number of the field

Ø  r.fno()

Get the serial number of field F of record r in a table sequence

Ø  r.key()

Get the primary key value of a record

Ø  r.modify()

Modify the field values of a record

Ø  r.record()

Modify field values of a record with members of a sequence

Ø  v.v()

Get the primary key value of the record pointed by a referencing field