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.

More:

Field Help Data