Click or drag to resize

LinkarCltSelect_Text Method (String, String, String, String, String, SelectOptions, DATAFORMATCRU_TYPE, String, Int32)

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

Namespace:  LinkarClient
Assemblies:   LinkarClientCore (in LinkarClientCore.dll) Version: 2.1.0.0
  LinkarClientMono (in LinkarClientMono.dll) Version: 2.1.0.0 (2.1.0.0)
  LinkarClient (in LinkarClient.dll) Version: 2.1.0.0 (2.1.0.0)
Syntax
public string Select_Text(
	string filename,
	string selectClause = "",
	string sortClause = "",
	string dictClause = "",
	string preSelectClause = "",
	SelectOptions selectOptions = null,
	DATAFORMATCRU_TYPE outputStringType = DATAFORMATCRU_TYPE.MV,
	string customVars = "",
	int receiveTimeout = -1
)

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.
outputStringType (Optional)
Type: LinkarCommonDATAFORMATCRU_TYPE
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 (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: String
Returns an object of type LkString with the results of the operation.
Exceptions
ExceptionCondition
SocketException

Thrown when there are communication problems between LINKAR Client and LINKAR Server

LkException

Thrown when there are errors in LINKAR Client or LINKAR Server

Examples
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();
DATAFORMAT_TYPE outputStringType = DATAFORMAT_TYPE.MV;
string result = lkClt.Select_Text(filename, selectClause, sortClause, dictClause, preSelectClause, selectOptions, outputStringType);
See Also