I see the file geodatabase writer has pre and post writer SQL options. So I assume I can do some deletion before inserting. Can I do "delete from table where attribute = 'attributeValue'"? Not sure what the syntax should be.
Solved
Is it possible to use pre-write SQL to delete features in a file geodatabase feature class?
+11- Contributor
Best answer by hkingsbury
A better approach would be to use a FeatureWriter to delete these features before they get written. You can add a WHERE Clause to filter out those you want to remove
+54- Celebrity
- Best Answer
A better approach would be to use a FeatureWriter to delete these features before they get written. You can add a WHERE Clause to filter out those you want to remove
The problem is that the pre and post SQL does not have any notion of feature attributes, so you cannot reference any feature attributes in the SQL. However, you can reference private or public parameters.
If you need to delete based on a feature attribute, there is the DatabaseDeleter transformer, or you can look into the suggestion from @hkingsbury
+11- Contributor
@hkingsbury and @david_r, thanks for the advice. I will try use where clause. Basically delete existing records before inserting new ones. Use this for RDBM like Oracle all the time, never used against a file geodatabase.
Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.