HomePage esProc Function Reference create() r.create() ＜Previous |

r.create()

Read（554） Label: copy, new table sequence,

Description:

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

Syntax:

r.create()

Note:

If there’s a key defined in record r, then copy the key at the same time.

Parameter:

r

A record

Return value:

Empty table sequence

Example:

Generate an empty table sequence from an average record:

 

A

 

1

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

2

=A1(1).create()

 

Create an empty table of same structure as A1(1) .

Generate an empty table sequence from a record with the key:

 

A

 

1

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

2

=A1.keys(DEPT)

 

3

=A1(1).create()

Generate an empty table sequence by copying the data structure of the record A1(1) and the key .