XData

XData - Single Sage 50 data

Description

  This function is only available for Sage 50 Canadian edition

This function returns single data from the Sage 50 database.

Parameters

Table [Optional]

Database table from which the data will come.

Expression [Optional]

Column to fetch or expression to evaluate.

Indices [Optional]

Index of the row to return or indices of the rows on which to evaluate an expression.

Dataset [Optional]

Custom dataset to use.

Connections [Optional]

Sage 50 connection to query. If left empty, the default connection will be utilized.

Examples

It is strongly recommended to utilize an Excel cell address (ex. A1:B19) containing the information of the parameters requested in all Logicim XLGL functions, such as names or codes. This practice adds flexibility to your worksheet and will ensure the coherence of your results. Moreover, the use of quotation marks (") is essential when the parameters are manually written in the arguments function window.

Returns a single data from table tCustomr for column sName and row 1

=XData("tCustomr", "sName", 1)