Returns the query result in a relational table format.
* filename |
string
|
|
File or table name defined in Linkar Schemas. Table notation is: MainTable[.MVTable[.SVTable]] |
selectClause
|
string |
|
fragment of the phrase that indicate 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 |
|
the list of dictionary definitions to be read, separated by a space. If dictionary IDs are not indicated the function will read the complete entire items. For example CUSTOMER DATE ITEM
|
tableOptions |
See below
|
defines several options. |
|
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. |
TABLE output format uses the defined control characters in EntryPoints Parameters .Table Row Separator and Column Row Separator.
By default:
| • | TAB char(9) for columns. |
• VT char(11) for rows.
tableOptions. All GetTable function options
rowHeaders |
|
Include headings in first row MAINLABEL (main headings), SHORTLABEL (short label headings), and NONE (without headings)
|
|
rowProperties |
boolean |
First row contains property names.
|
|
onlyVisibles |
boolean |
Use only Visible Schemas and Properties
|
|
usePropertyNames |
boolean |
Use Properties and Table names.
|
|
repeatValues |
boolean |
Repeat common attributes in MV and SV groups
|
|
applyConversion |
boolean |
Execute Conversions: With Dictionaries, conversion defined in the dictionary, with Schemas conversions defined in Linkar Schemas.
|
|
applyFormat |
boolean |
Execute Formats. With Dictionaries, formats defined in the dictionary, with Schemas formats defined in Linkar Schemas.
|
|
calculated |
boolean |
return the resulting values from the calculated dictionaries.
|
|
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. This must be greater than 0
|
numPage |
Numeric |
1 |
in case of pagination indicates the number of records by page. This must be greater than 0
|
There are 4 constructors for each possible Schema Type:
| • | LKSCHEMAS Schema Type. |
| • | SQLMODE Schema Type. |
| • | DICTIONARIES Schema Type. Returns the query using the file dictionaries. |
| • | NONE Schema Type. |
| • | LKSCHEMAS options: Returns the result using the properties defined in Linkar. |
| • | RowHeaders.TYPE |
| • | RowProperties |
| • | OnlyVisibles |
| • | UsePropertyNames |
| • | RepeatValues |
| • | ApplyConversion |
| • | ApplyFormat |
| • | Calculated |
| • | SQLMODE options: Returns the result using the properties defined in Linkar in SQL format. Can make inquiries to the Parent Table attributes or child MV or SV tables. Some examples are: |
Customers LK.CUSTOMERS file.
Items LK.ITEMS file
Orders LK.ORDERS file
Orders.MvItems MV group named MvItems in the LK.ORDERS file
Orders.MvItems.SvDeliveryDates SV group named SvDeliveryDates in the MV MvItems group.
| • | OnlyVisibles |
| • | ApplyConversion |
| • | ApplyFormat |
| • | Calculated |
In this Schema type the RowHeaders optionTYPE value is NONE and the RowProperties, UsePropertyNames and RepeatValues value is true.
| • | DICTIONARIES options: Returns the query using the file dictionaries. |
| • | RowHeaders.TYPE |
| • | RepeatValues |
| • | ApplyConversion |
| • | ApplyFormat |
| • | Calculated |
In this Schema type the RowProperties, OnlyVisibles and UsePropertyNames options type value are false.
| • | NONE options: Returns the query using attribute numbers (a 0, a1, f0 1....) |
| • | RowHeaders.TYPE |
| • | RepeatValues |
In this Schema type RowProperties, OnlyVisibles, UsePropertyNames, ApplyConversion, ApplyFormat and Calculated options value are always false.
