| OperationArgumentsGetGetTableArgs Method |
Linkar Framework .NET (Core and Framework)
Compose the 3 items (CUSTOMVARS, OPTIONS and INPUTDATA) of the GetTable operation.
Namespace: Linkar.FunctionsAssembly: 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
)
Public Shared Function GetGetTableArgs (
filename As String,
selectClause As String,
dictClause As String,
sortClause As String,
tableOptions As TableOptions,
customVars As String
) As String
public:
static String^ GetGetTableArgs(
String^ filename,
String^ selectClause,
String^ dictClause,
String^ sortClause,
TableOptions^ tableOptions,
String^ customVars
)
static member GetGetTableArgs :
filename : string *
selectClause : string *
dictClause : string *
sortClause : string *
tableOptions : TableOptions *
customVars : string -> string
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
StringA string ready to be used in Linkar.ExecuteDirectOperation and Linkar.ExecutePersistentOperation.
See Also