Primer s poizvedbo in branjem podatkov iz okna v P

Example with Query and Reading Data from PANTHEON Window

Make a clone of report '025 - Price List by Categories' that is in the program menu 'Settings | Items | Item Reports' with a simplified dataset that will contains only data from an items table; ,tem ID, name, both classifications, and set of item. We will read the condition for the query from the text components in the PANTHEON window. You can also combine more conditions.

Drag and drop the query object to the tab Data and set the following properties:

Name = 'qryItem'

UserName =  'qryItem'

SQL = 'select * from vHE_SetItem where acIdent like :p'

Params,Name = 'p'

Params.DataType = 'String'

Params.Value = 'GetFormValue('SifMSizpis.fIdent')+'%''

On "Page1" click on title of band "Detail" and select dataset 'qryItem'.

Put next datafields to this band:

acIdent, acName, acClasif, acClasif2, and acSetOfItem.

Also arrange texts in the table header.

As a parameter value we are using function "GetFormValue" which gets value in edit-box using for filter on the form.

Note: Other filters from windows will not be taken into account.