Please enable JavaScript to view this site.

Executes a query in the database.

 

 

* filename

string

 

 

File name being selected.
For example LK.ORDERS

selectClause

 

string

 

fragment of the phrase that indicates the selection condition

For example WITH CUSTOMER = '1'

 

sortClause

 

string

 

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

 

string

 

A list of dictionary definitions to read, separated by space. If dictionary IDs are not indicated the function will return entire items.

For example CUSTOMER DATE ITEM

preSelectClause

 

string

 

Optional statement to execute before the main Select. More details below.

selectOptions

See below

 

 

 

Define several options

outputStringType

 

 


Format of the data to be returned: MV, XML, XML_DICT, XML_SCH, JSON, JSON_DICT, JSON_SCH.

customVars

string

 

 

This is a free text field to send in the transaction. If not empty, subroutine SUB.LK.MAIN.CONTROL.CUSTOM will be called. Add custom code to that subroutine to define special behaviours for some or all transactions.

 

receiveTimeout

Numeric

 

-1

0

 

This is the maximum time in seconds that the client will wait for a response. Use 0 for no timeout. This is a function-specific override : -1 in a Persistent function defaults back to the timeout defined in the LinkarClt constructor.

 

selectOptions. Contains the options for Select functions

 

onlyRecordId

boolean

false

returns just the selected record codes

 

pagination

boolean

false

indicates if pagination is being used or not

 

regPage

Numeric

10

in case of pagination, indicates the number of records by page. It must be greater than 0

 

numPage

Numeric

1

in case of pagination indicates the page to obtain. This must be greater than 0.

 

calculated

boolean

false

return the resulting values from the calculated dictionaries.

 

conversion

boolean

false

execute the defined conversions in the dictionaries before returning.

 

formatSpec

boolean

false

execute the defined formats in the dictionaries before returning.

 

originalRecords

boolean

false

return a copy of the records in MV format.