Data Sources

Tip: This section applies to both views and CursorAdapters.

Clicking the Data Sources button at the bottom of the views and CursorAdapter Properties page opens the Data Sources form. You use the Data Sources form to create a Data Sources record that defines the elements of the view and CursorAdapter filter WHERE clause for the data sources that you will use in your application.

Tip: On the Properties page of views and CursorAdapters, you can select the Data Source record to be used for the view or CursorAdapter. If you make no selection, VPME assumes that the data source is Visual FoxPro.

VPME comes with Data Source records that define the WHERE clause elements for Visual FoxPro and SQL Server.

To create a Data Source record, enter values into the fields on the Data Source form as follows:

       Name: A name to identify the data source.

       WHERE Wildcard: When the LIKE operator is used when filtering on a character field/expression and the filter variable contains a partial value (the character string in the variable is shorter than the width of the field/expression), many databases require that an additional wildcard character be included. This field is used to enter an expression that defines the character string that is added to the end of the partial value.

Because filters for multiple purposes can be defined for a single view or CursorAdapter, the filters that are not being used at any given point must be bypassed, meaning the variables in the bypassed filters must contain values that will cause those filters to not filter out any records. The remaining fields on this form are used to define the values that will cause range filters to be bypassed. Range filter variable names include the suffixes _cMin, _cMax, _nMin, _nMax, _tMin, and _tMax.

       Bypass WHERE Variable cMin: This field is used to enter an expression that defines the character string for which no character value in the filtered field/expression will be lower.

       Bypass WHERE Variable cMax: This field is used to enter an expression that defines the character string for which no character value in the filtered field/expression will be higher.

       Bypass WHERE Variable dMin: This field is used to enter an expression that defines the date for which no date or datetime in the filtered field will be lower.

       Bypass WHERE Variable dMax: This field is used to enter an expression that defines the date for which no date or datetime in the filtered field will be higher.

       Bypass WHERE Variable nMin: This field is used to enter an expression that defines the numeric value for which no numeric, float, double, or integer value in the filtered field will be lower.

       Bypass WHERE Variable nMax: This field is used to enter an expression that defines the numeric value for which no numeric, float, double, or integer value in the filtered field will be higher.

More:

Rename