getlimit_get_searchvalues_.htm
Navigation: ABC Library Reference > QueryClass > QueryClass Methods >====== GetLimit (get searchvalues) ====== | |
GetLimit( name [ ,lower ] [ ,upper ] [ ,equal ] ), PROTECTED
GetLimit | Gets the QueryClass object's search values. |
name | A string constant, variable, EQUATE, or expression containing the queryable item to set. Queryable items are established by the AddItem method. |
lower | A CSTRING variable to receive the filter's lower boundary. |
upper | A CSTRING variable to receive the filter's upper boundary. |
equal | A CSTRING variable to receive the filter's exact match. |
The GetLimit method gets the QueryClass object's search values. The Ask or SetLimit methods set the QueryClass object's search values.
Implementation:
The GetFilter method generates filter expressions using the search values. The generated filter expression searches for values greater than lower, less than upper, and equal to equal.
Example:
QueryClass.Ask PROCEDURE(BYTE UseLast=1)
I USHORT,AUTO
EV CSTRING(1000),AUTO
CODE
SELF.Reset
LOOP I = 1 TO RECORDS(SELF.Fields)
GET(SELF.Fields,I)
EV = CLIP(EVALUATE(SELF.Fields.Name))
IF EV
SELF.SetLimit(SELF.Fields.Name,,,EV)
END
END
RETURN Level:Notify
getlimit_get_searchvalues_.htm.txt · Last modified: 2021/04/15 15:57 by 127.0.0.1