Q
QCH(expN1,expN2)
Data Format Returned: X
Returns
the quantity change given and action and quantity. Pass the action
and quantity fields from inv_use
to this function.
Parameters
Variable | Status | Description |
---|---|---|
expN1 | Required | Usage action. From Inv_Use.Action .
|
expN2 | Required | Quantity.
From Inv_Use.Quantity . |
QOH(expC,expD)
Data Format Returned: X
Returns the quantity on hand for a specific inventory item at the end of a specific day.
Parameters
Variable | Status | Description |
---|---|---|
expC | Required | Inventory ID. |
expD | Required | Date to calculate until. Defaults to today. |
QueryFilter(expC)
Data Format Returned: R
Returns
a description of the filter expression that was used to qualify records
when the query was run. This function will examine both Filter
and Having
expressions for the query. The only expressions which are included in
the return value are Ask
and Value
expressions. Join
(links between tables)
and Var
expressions are assumed to be internal to the query and are ignored.
Parameters
Variable | Status | Description |
---|---|---|
expC | Optional | Name of alias to examine. If not passed, the currently selected alias is assumed. |
QueryFilter()
returns a description of any
query parameters that are either entered as a value under the Filters
section in the Query Designer dialog box,
or as an Ask Filter added under
the Query Designer (can be defined
separately at the time the query or report is run).
QueryGroup(expL,expN,expC)
Data Format Returned: R
Returns the group by specification of records in a query. The value returned can be either a descriptive list of groups or a group by expression.
Parameters
Variable | Status | Description |
---|---|---|
expL | Optional | Determines if return value is expression
or English description of group bys. If passed as true (.T. ),
an expression is returned. If passed as false (.F. ),
description is returned. If not passed, false is assumed.
|
expN | Optional | The maximum level of groups to return. If multiple group bys are defined in the query, you can limit the depth to which this function returns group bys by setting this value. If passed as zero or not passed, all group bys are returned (this is the default). |
expC | Optional | Name of alias to examine. If not passed, the currently selected alias is assumed. |
QueryOrder(expL,expN,expC)
Data Format Returned: R
Returns the sort order of records in a query. The value returned can be either a descriptive list of sort orders or an order expression that can be used in report data grouping.
Parameters
Variable | Status | Description |
---|---|---|
expL | Optional | Determines if return value is expression
or English description of sort. If passed as true (.T. ),
a data grouping expression is returned. If passed as false (.F.),
description is returned. If not passed, false is assumed.
|
expN | Optional | The maximum level of sorts to return. If multiple sort orders are defined in the query, you can limit the depth to which this function returns sorts by setting this value. If passed as zero or not passed, all sorts are returned (this is the default). |
expC | Optional | Name of alias to examine. If not passed, the currently selected alias is assumed. |