LinkarCltSelect Method

Executes a Query in the Database, in a synchronous way.

Persistent Method.

Namespace: LinkarClient
Assembly: LinkarClientCOM (in LinkarClientCOM.dll) Version: 2.1.0.0 (2.1.0.0)

Syntax

public LkData Select(
	string filename,
	string selectClause = "",
	string sortClause = "",
	string dictClause = "",
	string preSelectClause = "",
	SelectOptions selectOptions = null,
	string customVars = "",
	int receiveTimeout = -1
)

Public Function Select ( 
	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 customVars As String = "",
	Optional receiveTimeout As Integer = -1
) As LkData

public:
LkData^ Select(
	String^ filename, 
	String^ selectClause = L"", 
	String^ sortClause = L"", 
	String^ dictClause = L"", 
	String^ preSelectClause = L"", 
	SelectOptions^ selectOptions = nullptr, 
	String^ customVars = L"", 
	int receiveTimeout = -1
)

member Select : 
        filename : string * 
        ?selectClause : string * 
        ?sortClause : string * 
        ?dictClause : string * 
        ?preSelectClause : string * 
        ?selectOptions : SelectOptions * 
        ?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 _customVars = defaultArg customVars ""
        let _receiveTimeout = defaultArg receiveTimeout -1
*)
-> LkData

Parameters

filename: Type: SystemString
File name. For example LK.ORDERS
selectClause (Optional): Type: SystemString
Fragment of the phrase that indicate the selection condition. For example WITH CUSTOMER = '1'
sortClause (Optional): Type: SystemString
Fragment of the phrase that indicates 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 (Optional): Type: SystemString
Is the list of dictionaries to read, separated by space. If dictionaries are not indicated the function will read the complete buffer. For example CUSTOMER DATE ITEM
preSelectClause (Optional): Type: SystemString
It's an optional statement that will execute before the main Select
selectOptions (Optional): Type: LinkarCommonSelectOptions
Object that defines the different reading options of the Function: calculated, dictionaries, conversion, formatSpec, originalRecords, onlyItemId, pagination, regPage, numPage.
customVars (Optional): Type: SystemString
It's a free text that will travel until the database to make the admin being able to manage additional behaviours in the standard routine SUB.LK.MAIN.CONTROL.CUSTOM. This routine will be called if the argument has content.
receiveTimeout (Optional): Type: SystemInt32
It's the maximum time in seconds that the client will keep waiting the answer by the server. By default -1 (wait indefinitely).

Return Value

Type: LkData
Retorna un objeto de tipo LkData con los resultados de la operación.

Examples

C++

Copy

LinkarClt lkClt = new LinkarClt();
CredentialsOptions crdOpt = new CredentialsOptions("127.0.0.1", 11300, "admin", "admin", "ENTRYPOINT");
lkClt.Login(crdOpt);

string filename = "LK.CUSTOMERS";
string selectClause = "";
string sortClause = "BY CODE";
string dictClause = "";
string preSelectClause = "";
SelectOptions selectOptions = new SelectOptions();
LkData lkDataSelect = lkClt.Select(filename, selectClause, sortClause, dictClause, preSelectClause, selectOptions);

Dim lkClt As LinkarClt = New LinkarClt
Dim crdOpt As CredentialsOptions = New CredentialsOptions("127.0.0.1", 11300, "admin", "admin", "ENTRYPOINT")
lkClt.Login(crdOpt)

Dim filename As String = "LK.CUSTOMERS"
Dim selectClause As String = ""
Dim sortClause As String = "BY CODE"
Dim dictClause As String = ""
Dim preSelectClause As String = ""
Dim selectOptions As SelectOptions = New SelectOptions
Dim lkDataSelect As LkData = lkClt.Select(filename, selectClause, sortClause, dictClause, preSelectClause, selectOptions))

Reference

LinkarClt Class

LinkarClient Namespace

LinkarCltAddLanguageSpecificTextSet("LSTC06776_0?cpp=::|nu=.");Select Method

Parameters

Return Value

Reference

LinkarCltSelect Method