I have a file geodatabase that i need to update weekly with a CAD file. How i can set up the update on the file geodatabase? I am using Esri Geodatabase (File Geodb ArcObjects)
Thank you,
David
Question
Update File Geodatabase
Hi,
This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.
Hi,
look at this article: http://fmepedia.safe.com/articles/Samples_and_Demos/Updating-Inserting-and-Deleting-features-in-an-unversioned-Geodatabase
The principle for updating is the same as for deleting.
You can also consider using the DatabaseUpdater (http://docs.safe.com/fme/html/FME_Transformers/Default.htm#Transformers/databaseupdater.htm%3FTocPath%3DFME%20Transformers%7CDatabase%7C_____3). It does the same thing, but with a different GUI, and might be a bit more intuitive.
David
Hi David,
I am using the SQL Statement To Execute Before Trasnlation.
delete from ROOMS
where BLDGFL=$(EnterBLDGFL)
$(EnterBLDGFL) = variable enter by the user.
I get this error. Error executing SQL: 'The table was not found.'
The table is there. I switch from file GDB to Personal GBD.
Hi,
look at the first link I posted, that works fine for File Geodatabases. Set the writer in DELETE mode and set the table primary key (probably BLDGFL in your case) in the output feature type.
David
Hi,
regarding the SQL statement: for a Personal GDB you must use MS Access syntax. That sometimes means you'll have to put square brackets around your table and/or field names, e.g.
delete from [ROOMS] where [BLDGFL]='$(EnterBLDGFL)'
Notice how you'll have to put single quotation marks if BLDGFL is a character field.
David