Microsoft Access Reader: Feature Type Parameters

To access feature type parameters, click the gear icon on a feature type in the workspace. This opens the Feature Type Parameter Editor.

Tip  To always display the editor in FME Workbench, you can select View > Windows > Parameter Editor.

General

All feature types share similar General parameters, which may include Feature Type Name, Reader or Writer information, and Geometry.

In most Writer Feature Type parameter dialogs, you can also control Dynamic Schema Definitions. Some database formats accept Table or Index Qualifier prefixes on the output table feature type.

Important  These parameters apply only to a selected feature type, not to the entire writer. If a feature type parameter listed here conflicts with a writer-level parameter, then the writer parameter will be ignored and this feature type parameter will be used.

Table

WHERE Clause

An SQL WHERE clause can be applied to the attributes of the layer’s features to limit the set of features returned. If not specified, then all the rows are returned.

To construct a WHERE clause, click the browse button to open the editor. You can also type a WHERE clause directly in the parameter field.

If the WHERE clause SQL is invalid, the translation will fail.