Correct SQL syntax when on Iworkspace.executeSQL

Discussion created by hsiddique on Jul 12, 2013
Latest reply on Jul 16, 2013 by sachin.kanaujia.gis
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.