bDBServer:RecordFilter

Purpose

Defines a filter on a list of record numbers.

Class

bDBServer

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