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.
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.