Find Forms

When you click the Find toolbar control, VPM Enterprise displays a Find form. By setting a form's lStartWithFind property to .T., you can display a Find Form when a form starts up. The Find form allows you to quickly find and display records in the active table, view or CursorAdapter using the fields contained on the form. You determine the fields to be contained on the form.

The first thing you should know about the Find form is that there are two of them: the SQL Find Form and the Standard Find Form. The second thing you should know is when VPME uses one or the other.

       SQL Find Form: If a form's InitialSelectedAlias is a filtered view or CursorAdapter that uses special FIND<field name> parameter variables, VPME uses the SQL Find Form. You can override VPME and use the Standard Find Form for such a filtered view or CursorAdapter, but you would rarely want to do that.
See Find SQL for a detailed description of the SQL Find Form.

       Standard Find Form: If a form's InitialSelectedAlias is anything else, VPME uses the Standard Find Form. SeeFind - Standard for a description of the Standard Find Form.

Main Purpose of SQL Find Form

The main purpose of the SQL Find Form is limiting data transfer. Client-server applications can access huge amounts of data on a remote server. Using traditional local navigation techniques will slow client-server applications. To speed performance, you must use a data access technique that filters the amount of data transferred.

The SQL Find Form solves the data transfer problem by allowing you to present an interface when a form loads that lets application users enter values that filter the records to be transferred from the server.

Tip: To see examples of the SQL Find Form in action, run the VPME Sample Application and access the forms on the Data Employee Views menu.

Selecting Initial Record to Display

The default behavior of VPME forms is to display the first record in the current order index when a form starts up. Since the first record is rarely the record a user wants to view, the user must immediately use the Form Toolbar Find, Locate or List control to find the record the user wants to view.

The Find Forms allow you to display a record selection dialog when a form starts up. The user can then immediately select the record to be displayed. This saves time and may be easier for users to understand.

Tip: Set a form's lStartWithFind property to .T., to display a Find Form when a form starts up.


Find - Standard