Purpose
Defines a filter on a list of record numbers.
Class
Type
Access / Assign
Data Type
Array
Description
In some situations a filter is needed that is either very complex or is subject to no definable condition. For such cases the record filter serves. The record filter is defined by an array of record numbers that were determined before. Dependent on the access bDBServer:RecordFilterMode the array defines the records either in the filter is contained or to be excluded. With the access bDBServer:RecordFilterFlags the procedure of the record filter can be further affected.
Notes!
After the record filter was successfully defined the data server is on the first record that corresponds to the record filter.
A defined record filter can be removed again with the assignment of a NULL_ARRAY.
Samples
The following sample defines a record filter on the record numbers 3, 5, 11, 17 and 29.
LOCAL odbsCUSTOMER AS bDBServer
LOCAL aiRecNo AS ARRAY
// open database
odbsCUSTOMER := DBServer{"CUSTOMER"}
IF odbsCUSTOMER:Used
// define record filter
aiRecNo := {3, 5, 11, 17, 29}
odbsCUSTOMER:RecordFilterMode := DBRFM_INCLUDE
odbsCUSTOMER:RecordFilter := aiRecNo
ENDIF
The following sample checks whether a record filter is defined and removed it.
IF !EMPTY(odbsCUSTOMER:RecordFilter)
odbsCUSTOMER:RecordFilter := NULL_ARRAY
ENDIF
See Also
bDBServer:RecordFilterRemoveDuplicateRecNo()
Page url: http://www.YOURSERVER.com/index.html?bdbserver_recordfilter.htm