Data Sources Data
The SDATADDDS.DBF table contains a record for each different data source accessed by an application. A Data Source defines the source of data accessed through a view or cursoradapter (VFP, SQL Server, Oracle, etc.). The table has the following structure.
Because filters for multiple purposes can be defined for a single cursoradapter or view, 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. Filters on numeric, date and datetime fields can only be bypassed using a range of values. Filters on character fields can be bypassed using a single value or a range of values. The “mBypass_” fields allow the bypass range values to be defined for each data source.
|
Field Name |
Type |
Width |
Comments |
|
cPK |
Character |
48 |
PK field |
|
cName |
Character |
80 |
Name |
|
mBypassWildcard |
Memo |
|
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. |
|
mBypass_cMax |
Memo |
|
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. |
|
mBypass_cMin |
Memo |
|
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. |
|
mBypass_dMax |
Memo |
|
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. |
|
mBypass_dMin |
Memo |
|
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. |
|
mBypass_nMax |
Memo |
|
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. |
|
mBypass_nMin |
Memo |
|
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. |
