DirectFunctionsSelect Method

public static string Select(
	CredentialOptions credentialOptions,
	string filename,
	string selectClause = "",
	string sortClause = "",
	string dictClause = "",
	string preSelectClause = "",
	SelectOptions selectOptions = null,
	DATAFORMATCRU_TYPE outputFormat = DATAFORMATCRU_TYPE.MV,
	string customVars = "",
	int receiveTimeout = 0
)

Public Shared Function Select ( 
	credentialOptions As CredentialOptions,
	filename As String,
	Optional selectClause As String = "",
	Optional sortClause As String = "",
	Optional dictClause As String = "",
	Optional preSelectClause As String = "",
	Optional selectOptions As SelectOptions = Nothing,
	Optional outputFormat As DATAFORMATCRU_TYPE = DATAFORMATCRU_TYPE.MV,
	Optional customVars As String = "",
	Optional receiveTimeout As Integer = 0
) As String

public:
static String^ Select(
	CredentialOptions^ credentialOptions, 
	String^ filename, 
	String^ selectClause = L"", 
	String^ sortClause = L"", 
	String^ dictClause = L"", 
	String^ preSelectClause = L"", 
	SelectOptions^ selectOptions = nullptr, 
	DATAFORMATCRU_TYPE outputFormat = DATAFORMATCRU_TYPE::MV, 
	String^ customVars = L"", 
	int receiveTimeout = 0
)

static member Select : 
        credentialOptions : CredentialOptions * 
        filename : string * 
        ?selectClause : string * 
        ?sortClause : string * 
        ?dictClause : string * 
        ?preSelectClause : string * 
        ?selectOptions : SelectOptions * 
        ?outputFormat : DATAFORMATCRU_TYPE * 
        ?customVars : string * 
        ?receiveTimeout : int 
(* Defaults:
        let _selectClause = defaultArg selectClause ""
        let _sortClause = defaultArg sortClause ""
        let _dictClause = defaultArg dictClause ""
        let _preSelectClause = defaultArg preSelectClause ""
        let _selectOptions = defaultArg selectOptions null
        let _outputFormat = defaultArg outputFormat DATAFORMATCRU_TYPE.MV
        let _customVars = defaultArg customVars ""
        let _receiveTimeout = defaultArg receiveTimeout 0
*)
-> string 

Parameters

credentialOptions  CredentialOptions

Object with data necessary to access the Linkar Server: Username, Password, EntryPoint, Language, FreeText.

filename  String

Name of file on which the operation is performed. For example LK.ORDERS

selectClause  String  (Optional)

Statement fragment specifies the selection condition. For example WITH CUSTOMER = '1'

sortClause  String  (Optional)

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

dictClause  String  (Optional)

Space-delimited list of dictionaries to read. If this list is not set, all fields are returned. For example CUSTOMER DATE ITEM. You may use the format LKFLDx where x is the attribute number.

preSelectClause  String  (Optional)

An optional command that executes before the main Select

selectOptions  SelectOptions  (Optional)

Object with options to manage how records are selected, including calculated, dictionaries, conversion, formatSpec, originalRecords, onlyItemId, pagination, regPage, numPage.

outputFormat  DATAFORMATCRU_TYPE  (Optional)

Indicates in what format you want to receive the data resulting from the Read, New, Update and Select operations: MV, XML, XML_DICT, XML_SCH, JSON, JSON_DICT or JSON_SCH.

customVars  String  (Optional)

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.

receiveTimeout  Int32  (Optional)

Maximum time in seconds that the client will wait for a response from the server. Default = 0 to wait indefinitely.

Return Value

• Previously call to a saved list with the GET.LIST command to use it in the Main Select input
• Make a previous Select to use the result as the Main Select input, with the SELECT or SSELECT commands.In this case the entire sentence must be indicated in the PreselectClause. For example:SSELECT LK.ORDERS WITH CUSTOMER = '1'
• Exploit a Main File index to use the result as a Main Select input, with the SELECTINDEX command. The syntax for all the databases is SELECTINDEX index.name.value. For example SELECTINDEX ITEM,"101691"

Reference