Update File Geodatabase

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