CursorAdapter Filters

CursorAdapter filters are required to make VPME functionality such as One-To-Many forms, Related Pages forms, Related Forms, Referential Integrity Validation and SQL Find Forms work with CursorAdapters. After you set up the required filters for a CursorAdapter, wherever you use the CursorAdapter in your application, the functionality that requires the filters will be automatically turned on and available.

Tip: We realize that we are introducing the topic of CursorAdapter filters before you have reached the sections of this Userís Guide that describe the functionality that requires CursorAdapter filters. So, bear with us and be patient. The first time you go through this section the material may seem a little obtuse because you may not be familiar with the terms used and the functionality referenced. However, after you have gone through the later sections of the Userís Guide, come back to this section and the material will be more understandable.

Just Like View Filters

CursorAdapter Filters work just like View filters as discussed in View Filters. The main difference is that with views you use the VFP View Designer to set up the required view parameter filters. The View Designer automatically creates a WHERE clause for you that defines the view filters and inserts the WHERE clause into the Select statement for the view.

With CursorAdapters on the other hand, you must (1) manually create a WHERE clause that defines the filters and (2) manually insert your WHERE clause into either the Select statement on the Data Access page of the CursorAdapter Builder or into the SelectCmd property of your CursorAdapter class.


CursorAdapter Filters You Need and When You Need Them

CursorAdapter Select Command Where Clause

WHERE Clause Example

Inserting the WHERE Clause