Hi Bruce, Have you tried the SQLExecutor transformer? For new features just send them to the database. For deletes just run them through the transformer with a delete command For updates run them through the transformer with a delete AND send them to the database
I once did this sort of thing using the ArcSDEQuerier and it seemed to work fine. I believe you should be able to set the SQL to include an attribute, eg delete from myTable where myID = &attributeName Hope this helps Mark Ireland, Senior Product Specialist Safe Software Inc. Surrey, BC, CANADA support@ http://www.safe.com Solutions for Spatial Data Translation, Distribution and Access --- In [email protected], "Bruce Harold" <[EMAIL PROTECTED]> wrote: > > Hi Listers > > > > Has anyone tackled writing transactions to Oracle Spatial (Relational) in a > way which mimics the writers which support an update mode using the > fme_db_operation format attribute? I don't think the writer supports that > directly and I want to send adds and deletes through to Oracle rather than > recreating tables with the associated downtime. > > > > The target application is Intergraph G/Tech. > > > > Cheers > > > > Bruce. > > > > Bruce Harold > > Geographic Information Solutions > > <http://www.gis.co.nz> www.gis.co.nz > > Ph. (64) (0) 9 537 3247 > > Mb. (+64) (0) 21 2995995 > For insights into what's up at Safe Software and what's on the development horizon, visit Safe's blog at spatial-etl.blogspot.com. Safe Software has also made slides available that outline enhancements planned for FME 2007. The slides are from the "Road Ahead" presentation given on Day 2 of the FME Worldwide Users Conference. To view these slides, visit www.safe.com/2006uc. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/fme/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/fme/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
