call()

Description:

Call a cellset file and return the first result set.

Syntax:

call(dfx,arg1,…)

Note:

The function calls the cellset file dfx while passing in the parameter arg1,…, returns the first value that dfx returns, and ends the invocation. It is a non-cellset function and so can be used outside the cellset. The function will automatically use the @s option to search for the dfx among the file names with non-absolute paths in a specified order: Class path -> Search path -> Main path. The default main path is the current path.

When calling the call function, parameters arg1,... will be assigned to dfx’s parameters in order, which is irrelevant to the parameter names in dfx’s parameter list.

Parameters:

dfx

Cellset file

arg1,

Parameters

Options:

@r

Disable the default buffer call

Example:

Below are the contents of the cellset file C:\\test.dfx where arg1 is the cellset parameter:

 

A

B

1

=connect("demo").query("select * from Students1 where Age>?",arg1)

2

return A1

 

 

 

A

 

1

=call("C:\\test.dfx",15)

Call the cellset file, and return the first returned value. Query the data of students who are above 15 years old

 

Note:

Use the comma to separate the multiple results returned. E.g. return A1,B2.