数据库更新程序
根据指定的条件更新数据库表中的字段。
输入端口
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/../Skins/Default/Stylesheets/Images/transparent.gif)
此转换器接受任何功能。
Output Ports
This transformer has no output ports.
Parameters
Database To Update
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/../Skins/Default/Stylesheets/Images/transparent.gif)
选择表所在的格式和数据集,包括任何特定于格式的参数。
Parameters
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/../Skins/Default/Stylesheets/Images/transparent.gif)
指定要更新的表。单击Browse按钮从从数据库检索的列表中选择表。请注意,只有在完全指定了数据库格式、数据集和特定于格式的参数之后,才能选择此选项。
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/../Skins/Default/Stylesheets/Images/transparent.gif)
指定如何标识要更新的行。这可以通过匹配列或者通过WHERE子句.
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/../Skins/Default/Stylesheets/Images/transparent.gif)
Use a SQL WHERE clause to identify matching records to update. An example clause is the following:
id = 'roads'
匹配
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/../Skins/Default/Stylesheets/Images/transparent.gif)
Specify the columns and their values used to identify matching records. A record match occurs when the contents of the record for the columns listed exactly equal the corresponding value.
In the Table Column field, click the Browse button to select from a list of all the columns in the database table. Note this only works after you have completely specified the database format, dataset, format-specific parameters, and picked a table.
要更新的列
![关闭](http://www.baooytra.com/docs/fme/2017.0/html/FME_Desktop_Documentation/FME_Transformers/Transformers/../Skins/Default/Stylesheets/Images/transparent.gif)
指定要更新的列以及要用其更新的值。未列出、禁用或设置为“
从中的“浏览”按钮选择表后,将自动填充此表条目小部件表参数。
单击位于TableEntry小部件右侧的Reload按钮,用数据库表中的列重新填充表。注意:只有在完全指定了数据库格式、数据集、特定于格式的参数并选择了一个表之后,重新加载才起作用。
Automatic population fills the table with columns and tries to set their values with a convenient initial state. If a column had a value prior to populating, that value will be maintained after populating. Columns not already mapped will default to incoming attributes of the same name if one exists, otherwise it will default to “Do Nothing”.
Note that when theConditionparameter is匹配列,上匹配的列也无法更新。相反,可以考虑对条件使用WHERE子句。
使用说明
如果相应的编写器支持几何图形,则支持更新几何图形列。
注意:如果几何特征为空,更新可能会产生不一致的结果。有些编写器不更新空几何体,有些编写器将空几何体更新为空值。
有关写入程序如何响应更新现有行的更多信息,请参阅FME Readers and Writers帮助。
不像FME作家,fme\U db\U操作和fme_whereDatabaseUpdater输入功能不支持属性。
编辑变压器参数
使用一组菜单选项,可以通过引用工作空间中的其他元素来指定转换器参数。更高级的功能,如高级编辑器和算术编辑器,也可以在一些变压器。要访问这些选项的菜单,请单击在适用参数旁边。有关详细信息,请参阅变压器参数菜单选项.
变压器类别
搜索FME知识中心
在上搜索有关此变压器的示例和信息FME Knowledge Center.
技术历史
关联的FME函数或工厂:DatabaseUpdaterFactory