Question

Update File Geodatabase

  • 25 November 2014
  • 4 replies
  • 11 views

Hi, 

 

 

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

4 replies

Userlevel 4
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. 
Userlevel 4
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
Userlevel 4
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

Reply