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.
Note!
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:RecordFilter := aiRecNo
odbsCUSTOMER:RecordFilterMode := DBRFM_INCLUDE
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
Page url: http://www.YOURSERVER.com/index.html?bdbserver_recordfilter.htm