Click or drag to resize

OperationArgumentsGetGetTableArgs Method

Linkar Framework .NET (Core and Framework)


Compose the 3 items (CUSTOMVARS, OPTIONS and INPUTDATA) of the GetTable operation.

Namespace: Linkar.Functions
Assembly: Linkar.Functions (in Linkar.Functions.dll) Version: 2.3.1
Syntax
public static string GetGetTableArgs(
	string filename,
	string selectClause,
	string dictClause,
	string sortClause,
	TableOptions tableOptions,
	string customVars
)

Parameters

filename  String
File or table name defined in Linkar Schemas. Table notation is: MainTable[.MVTable[.SVTable]]
selectClause  String
Statement fragment specifies the selection condition. For example WITH CUSTOMER = '1'
dictClause  String
Space-delimited list of dictionaries to read. If this list is not set, all fields are returned. For example CUSTOMER DATE ITEM
sortClause  String
Statement fragment specifies the selection order. If there is a selection rule Linkar will execute a SSELECT, otherwise Linkar will execute a SELECT. For example BY CUSTOMER
tableOptions  TableOptions
Detailed options to be used, including: rowHeaders, rowProperties, onlyVisibe, usePropertyNames, repeatValues, applyConversion, applyFormat, calculated, pagination, regPage, numPage.
customVars  String
Free text sent to the database allows management of additional behaviours in SUB.LK.MAIN.CONTROL.CUSTOM, which is called when this parameter is set.

Return Value

String
A string ready to be used in Linkar.ExecuteDirectOperation and Linkar.ExecutePersistentOperation.
See Also