| LinkarCltSelect_Text Method (CredentialsOptions, String, String, String, String, String, SelectOptions, DATAFORMATCRU_TYPE, String, Int32) |
Executes a Query in the Database, in a synchronous way.
Direct 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 static string Select_Text(
CredentialsOptions credentialsOptions,
string filename,
string selectClause = "",
string sortClause = "",
string dictClause = "",
string preSelectClause = "",
SelectOptions selectOptions = null,
DATAFORMATCRU_TYPE outputStringType = DATAFORMATCRU_TYPE.MV,
string customVars = "",
int receiveTimeout = 0
)
Public Shared Function Select_Text (
credentialsOptions As CredentialsOptions,
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 outputStringType As DATAFORMATCRU_TYPE = DATAFORMATCRU_TYPE.MV,
Optional customVars As String = "",
Optional receiveTimeout As Integer = 0
) As String
public:
static String^ Select_Text(
CredentialsOptions^ credentialsOptions,
String^ filename,
String^ selectClause = L"",
String^ sortClause = L"",
String^ dictClause = L"",
String^ preSelectClause = L"",
SelectOptions^ selectOptions = nullptr,
DATAFORMATCRU_TYPE outputStringType = DATAFORMATCRU_TYPE::MV,
String^ customVars = L"",
int receiveTimeout = 0
)
static member Select_Text :
credentialsOptions : CredentialsOptions *
filename : string *
?selectClause : string *
?sortClause : string *
?dictClause : string *
?preSelectClause : string *
?selectOptions : SelectOptions *
?outputStringType : 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 _outputStringType = defaultArg outputStringType DATAFORMATCRU_TYPE.MV
let _customVars = defaultArg customVars ""
let _receiveTimeout = defaultArg receiveTimeout 0
*)
-> string
Parameters
- credentialsOptions
- Type: LinkarCommonCredentialsOptions
Object that defines the necessary data to access to the Linkar Server: Username, Password, EntryPoint, Language, FreeText.
- 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:
StringReturns an object of type
LkString with the results of the operation.
Exceptions Exception | Condition |
---|
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 CredentialsOptions crdOpt = new CredentialsOptions("127.0.0.1", 11300, "admin", "admin", "ENTRYPOINT");
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 = LinkarClt.Select_Text(crdOpt, filename, selectClause, sortClause, dictClause, preSelectClause, selectOptions, outputStringType);
Dim crdOpt As CredentialsOptions = New CredentialsOptions("127.0.0.1", 11300, "admin", "admin", "ENTRYPOINT")
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 outputStringType As DATAFORMAT_TYPE = DATAFORMAT_TYPE.MV
Dim result As String = LinkarClt.Select_Text(crdOpt, filename, selectClause, sortClause, dictClause, preSelectClause, selectOptions, outputStringType)
No code example is currently available or this language may not be supported.
No code example is currently available or this language may not be supported.
See Also