Please enable JavaScript to view this site.

Returns a list of all Schemas defined in Linkar Schemas or from the MV account associated with the current EntryPoint.

 

 

lkSchemasOptions

See below

 

The options to request a specific Schema Type:

: LKSCHEMAS, SQLMODE, or DICTIONARIES.

outputStringType



Indicates the format of the output data : MV, XML, JSON or TABLE

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.

customVars

string

char*

 

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.

 

 

lkSchemasOptions. All LkSchemas 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

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 3 constructors for each possible Schema Type:

 

LKSCHEMAS options: Returns the list of schemas defined in Linkar Schemas.
RowHeaders.TYPE
RowProperties
OnlyVisibles

 

SQLMODE options: Returns the list of schemas defined in Linkar Schemas in SQL format. It creates independent Mv and SV relational child tables. For instance in the Demo account the LK.DEMOFILES generates this table:

 

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 named SvDeliveryDates from the MV MvItems group.

RowHeaders option: Formed TYPE value is NONE and RowProperties option is true.

OnlyVisibles

 

 

DICTIONARIES options: Returns the account files list.
RowHeaders.TYPE

 

RowProperties and OnlyVisibles options are always false.