LinkarCltSelectT Method (CredentialsOptions, String, String, String, String, String, SelectOptions, String, Int32)

public List<T> Select<T>(
	CredentialsOptions credentialsOptions,
	string filename,
	string selectClause = "",
	string sortClause = "",
	string dictClause = "",
	string preSelectClause = "",
	SelectOptions selectOptions = null,
	string customVars = "",
	int receiveTimeout = 0
)

Public Function Select(Of T) ( 
	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 customVars As String = "",
	Optional receiveTimeout As Integer = 0
) As List(Of T)

public:
generic<typename T>
List<T>^ Select(
	CredentialsOptions^ credentialsOptions, 
	String^ filename, 
	String^ selectClause = L"", 
	String^ sortClause = L"", 
	String^ dictClause = L"", 
	String^ preSelectClause = L"", 
	SelectOptions^ selectOptions = nullptr, 
	String^ customVars = L"", 
	int receiveTimeout = 0
)

member Select : 
        credentialsOptions : CredentialsOptions * 
        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 0
*)
-> List<'T> 

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.

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).

Type Parameters

T

Exclusive for .NET & Mono

Some functions can accept and return values directly from a class. These classes must contain extra information in their properties to be able to link with the data sent or received. The data dump regarding the classes is made through reflection, record by record. This means that it will take a little longer to process each record.

For this reason, it is not recommended that a great number of records be obtained at once.

This is achieved through the following metadata:

• MVProperty - This attribute tells the Linkar client that he must try to supply this field with the operations information. The following properties are used to link the feature with its internal value
  • AttributeNumber - Number of the property attribute. It is compulsory to specify this property or the Dictionaryname property.
  • DictionaryName - The name of the property dictionary. It is compulsory to specify this property or AttributeNumber property.
  • InternalType - Data conversions that will be made in the client. None: default value, indicates that the conversion type is not required by the client.
  • InternalDate - The value is saved as an internal date.
  • FormatedDate - The value is saved as a formatted date.
• MVCalculated - The client must try to supply this calculated field with the operations data. The following properties are used to link the feature with its internal value:
  • DictionaryName - The name of the calculated dictionary. This property is mandatory.
  • InternalType - Data conversions that are made in the client
  • None - Default value, a conversion type is not required by the client.
  • InternalDate - Value is saved as an internal date.
  • FormatedDate - Value is saved as a formatted date.
• MVList - This is used on list type objects and indicates that the Linkar client must go across to collect their values and complete them. When situated in the main class is understood that it is a multivalue list, in a secondary class, they will be treated as subvalues, and from there to next they will be ignored.

Return Value

Reference