f.append()

Description:

Cocatenate two same-structure composite table.

Syntax:

f.append( f’,p)

 

Note:

The function appends an unencrypted composite table file f’ to another composite table file f. The two should have same structure, otherwise the appending will fail. Once the appending fails, use rollback() function to restore the previous state. Parameter p can be omitted if f is an unencrypted composite table file.

Parameters:

f’

A composite table file

p

The write password for composite table file f

Options:

@x

Delete f’after the appending

Return value:

A composite table file

Example:

 

A

 

1

=file("D:\\append1.ctx")

 

2

=A1.create(#EID,NAME,DEPT,SALARY)

Create the composite table’s base table

3

=demo.cursor("select EID,NAME,DEPT,SALARY from EMPLOYEE where EID<10 order by  EID")

 

4

=A2.append(A3)

Append cursor records to the entity table

5

=file("D:\\append2.ctx")

 

6

=A5.create(#EID,NAME,DEPT,SALARY)

Create the composite table’s base table

 

7

=demo.cursor("select EID,NAME,DEPT,SALARY from EMPLOYEE where  EID>10and  EID<20  order by  EID")

 

8

=A6.append(A7)

Append cursor records to the entity table

9

=A1.append(A5)

Append unencrypted composite table f’ to another unencrypted composite table f

10

=A9.create().cursor().fetch()

11

=file("D:\\append3.ctx")

 

12

=A11.create(#EID,NAME,DEPT,SALARY;;"123":"11")

Create an encrypted base table for the composite table

13

=demo.cursor("select EID,NAME,DEPT,SALARY from EMPLOYEE where EID<5 order by  EID")

 

14

=A12.append(A13)

Append cursor records to the entity table

 

15

=A11.append(A5,"123")

Append unencrypted composite table f’ to encrypted composite table f

16

=A11.create(;;"11").cursor().fetch()

 

arguments()

Description:

Return a list of the current dfx file’s argument names.

Syntax:

arguments()

Note:

The function returns a list of the current dfx file’s argument names.

Return value:

A sequence

Example:

 

A

 

1

=arg1+" world!"

 

2

=arg2+88

 

3

=arguments()

Return a list of the current dfx file’s argument names