AnsweredAssumed Answered

IWorkspace.ExecuteSQL and edit sessions

Question asked by andycanfield on Feb 22, 2012
Latest reply on Feb 24, 2012 by andycanfield
Is there any way to get something like ExecuteSQL to work against the edit cache? Here is my issue:

I have an app where a user is making edits in ArcMap and then based on those edits I need to update up to 600,000 records across about five to ten tables. IWorkspace.ExecuteSQL does this very quickly. However anything created in the current edit session doesn't get updated because it hasn't been saved back to the database. So what I really need is that same performance but to execute against the edit cache or wherever those features are being stored before being committed to the database where ExecuteSQL can reach them.

Also does ExecuteSQL work against versions other than default? If so how do I get it to do that?

Outcomes