topic Re: Correct SQL syntax when on Iworkspace.executeSQL in ArcObjects SDK Questions

Correct SQL syntax when on Iworkspace.executeSQL

HalilSiddique — Fri, 12 Jul 2013 13:45:21 GMT

Hi All,

I am working on a VBA app, and I am having trouble with running sql using the executeSQL method.

I have a table and a SDE featureclass, i want to insert all the records from a particular field from the featureclass into the table.
The code i am trying to run is..

 
               sql = " insert into DP_TEMP (DP_REF)" + _
                       " select DP_REF " + _
                       " from SY_CSY_CPAT.CITY_DEVELOPMENT_PIPELINES"
               pWS.ExecuteSQL sql

But when the code is run - no errors appear, but the table is empty.

Has anyone got any idea on why it is not working.
Thanks

Re: Correct SQL syntax when on Iworkspace.executeSQL

HalilSiddique — Tue, 16 Jul 2013 13:21:26 GMT

Any inkling anyone?

Re: Correct SQL syntax when on Iworkspace.executeSQL

SachinKanaujia — Tue, 16 Jul 2013 14:20:38 GMT

Are you able to execute the same insert query from a sql prompt or sql editor and not here? Its always better to have a schema name qualification for the tables to be sure that they are modified correctly.