User Tools

Site Tools


updatequery_set_default_query_interface_.htm
Navigation:  ABC Library Reference > BrowseClass > BrowseClass Methods >====== UpdateQuery (set default query interface) C6H0009.jpg ====== Previous pageReturn to chapter overviewNext page

UpdateQuery( querymanager, [casesensitive])

blk2blue.jpg

UpdateQuery Defines a default query interface for the BrowseClass object.
querymanager The label of the BrowseClass object's QueryClass object. See QueryClass for more information.
casesensitive A numeric constant, variable, EQUATE, or expression that indicates the case sensitivity of the query expression. If this parameter is omitted the query is case insensitive.

The UpdateQuery method defines a default query interface (dialog) for the BrowseClass object.

TipBox.jpg

You may use the UpdateQuery method in combination with the QueryClass.AddItem method to define a query interface that contains the displayed fields plus other queryable items.

Implementation:

The UpdateQuery method sets the value of the Query property, then calls the QueryClass.AddItem method for each displayed field, so that each displayed field accepts filter criteria in the query dialog.

Example:

QueryForm  QueryFormClass

QueryVis   QueryFormVisual

BRW1       CLASS(BrowseClass)

Q           &CusQ

          END

CusWindow.Init PROCEDURE()

 CODE

!open files, views, window, etc.

IF DefaultQuery

 BRW1.UpdateQuery(QueryForm)

ELSE

 BRW1.Query &= QueryForm

 QueryForm.AddItem('UPPER(CUS:NAME)',,)

 QueryForm.AddItem('UPPER(CUS:CITY)',,)

 QueryForm.AddItem('CUS:ZIP_CODE',,)

END

RETURN Level:Benign

See Also:     Query, QueryClass.AddItem

updatequery_set_default_query_interface_.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1