topic IWorkspace.ExecuteSQL UPDATE with file geodatabase in ArcObjects SDK Questions

IWorkspace.ExecuteSQL UPDATE with file geodatabase

PatriceLabbé — Mon, 01 Oct 2012 17:53:30 GMT

Hi,

Is it possible to use an UPDATE statement like the following one with file geodatabases (v9.3) :

UPDATE table_name SET field_name = another_field_name

This kind of code always throws an exception.

Thank you!

Re: IWorkspace.ExecuteSQL UPDATE with file geodatabase

LanceShipman — Mon, 01 Oct 2012 18:27:59 GMT

UPDATE should work. It's certainly working at 10.1. What does your update statement look like?

Re: IWorkspace.ExecuteSQL UPDATE with file geodatabase

PatriceLabbé — Mon, 01 Oct 2012 18:48:51 GMT

This works (set an arbitrary value):

string sql = "UPDATE hydro_so_100k SET HYD_NOM = 'nom', HYD_DESCR = 'description' WHERE FEU_NO like '%12%'"

These doesn't (update field value from another one's value):

string sql = "UPDATE hydro_so_100k SET HYD_NOM = HYD_NOM , HYD_DESCR = 'description' WHERE FEU_NO like '%12%'";

or

string sql = "UPDATE hydro_so_100k SET HYD_NOM = \"HYD_NOM\" , HYD_DESCR = \"HYD_DESCR\" WHERE FEU_NO like '%12%'";

I came across this link in my searches : http://forums.esri.com/Thread.asp?c=93&f=993&t=235859

At this point, file geodatabase does not support expressions in the SET clauses of an Update statement, we only support literal values. This is not a bug. We implemented what we needed, with the plan of expanding things over time.

It seems to confirm there were limitations with UPDATE statements. Is is still true with 9.3 version?

Re: IWorkspace.ExecuteSQL UPDATE with file geodatabase

LanceShipman — Mon, 01 Oct 2012 20:07:48 GMT

Support has been extended at 10.1, but not at 9.3.