GILOOKUP

Overview

The GILOOKUP function returns the value of a single field from a Generic Inquiry by specifying the keys of the single row to locate.

Syntax

This is the syntax for this function:

CODE

=GILOOKUP(Connection, Name, Column, Keys)

Arguments

This function has the following arguments:

Argument	Required/Optional	Description
`Connection`	Required	The name of the connection, as specified in the Connection Manager
`Name`	Required	The name of the Generic Inquiry
`Column`	Required	The specific field to be returned from the inquiry data
`Keys`	Required	One or more Key(s) to be used to filter the data

Additional Notes

For each Generic Inquiry that you use with the GILOOKUP function, you will need to explicitly specify the inquiry's key columns in the Generic Inquiries Options section of the Velixo Options window.

Example

CODE

=GILOOKUP("Demo", "AR-Invoices and Memos", "Status", "002263", "Overdue Charge")

Description

Assuming that Generic Inquiry Key Fields options for the AR-Invoices and Memos are configured as:

This function call returns the Status field for the record in the database where the ReferenceNbr field is 002263 and the Type field is Overdue Charge.

Result:

Closed