databasedeleter.
Delete rows in a database table based on the condition specified.
输入端口
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Skins/Default/Stylesheets/Images/transparent.gif)
This transformer accepts any feature.
输出端口
此变压器没有输出端口。
参数
数据库更新
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Skins/Default/Stylesheets/Images/transparent.gif)
Select the format and dataset where the table resides, including any format-specific parameters.
参数
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Skins/Default/Stylesheets/Images/transparent.gif)
指定表以从中删除行。单击浏览按钮以从数据库检索的列表中选择表。请注意,您只能在完全指定数据库格式,数据集和格式特定于格式的参数后选择此功能。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Skins/Default/Stylesheets/Images/transparent.gif)
指定如何识别要删除的行。这可以通过Match Column(s)或通过A.WHERE Clause。
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Skins/Default/Stylesheets/Images/transparent.gif)
使用SQL where子句来标识要删除的匹配记录。示例子句是以下内容:
ID ='道路'
匹配
![Closed](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Skins/Default/Stylesheets/Images/transparent.gif)
指定用于识别匹配记录的列及其值。当列列出的列的内容完全等于相应值时,会发生记录匹配。
在“表列”字段中,单击“浏览”按钮以从数据库表中的所有列的列表中进行选择。请注意,只有在完全指定数据库格式,数据集,格式的参数并选择表格后,才会工作。
Usage Notes
看到FME读者和作家(FME 2014支持的格式)>数据库编写器模式or specific writer documentation for more information on how writers will respond to deleting rows.
Unlike FME Writers,fme_db_operation和fme_where.attributes are not supported on DatabaseDeleter input features.
Editing Transformer Parameters
Using a set of menu options, transformer parameters can be assigned by referencing other elements in the workspace. More advanced functions, such as an advanced editor and an arithmetic editor, are also available in some transformers. To access a menu of these options, click在适用的参数。更多的备用ion, seeTransformer Parameter Menu Options。
Transformer Categories
搜索FME知识中心
搜索有关此变压器的样本和信息FME知识中心。