https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-open-a-cursor-based-on-a-query-not-querydef/m-p/1172876#M8123 <P>Found a solution based on the Database class instead of Geodatabase:</P><LI-CODE lang="csharp">var query = string.Format("select cast(forstgis.wimsidutil.nextwimsid({0}) " + "as number(38,0)) id from dual", unitId); using (var queryDesc = database.GetQueryDescription(query, "QueryLayer")) { queryDesc.SetObjectIDFields("id"); using (var table = database.OpenTable(queryDesc)) using (var cursor = table.Search()) { while (cursor.MoveNext()) { using (var row = cursor.Current) { return (int)row[0]; } } } }</LI-CODE> Wed, 11 May 2022 15:40:16 GMT FridjofSchmidt 2022-05-11T15:40:16Z https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-open-a-cursor-based-on-a-query-not-querydef/m-p/1167080#M8058 <P>In ArcObjects it is possible to return a cursor based on a query string with ISqlWorkspace.OpenQueryCursor(myQuery). I was wondering if and how this is possible in the ArcGIS Pro SDK.</P><P>The query is in fact calling an Oracle stored procedure which returns a number based on an input number:</P><LI-CODE lang="c">var myQuery = string.Format("select forstgis.wimsidutil.nextwimsid({0}) from dual", unitId);</LI-CODE><P>I tried to put this into a QueryDef and use Geodatabase.Evaluate(queryDef) like this:</P><LI-CODE lang="c"> var queryDef = new QueryDef { Tables = "dual", SubFields = string.Format("forstgis.wimsidutil.nextwimsid({0})", unitId) };</LI-CODE><P>However, Evaluate in this case throws a COMException (HRESULT: 0x80040351).</P><P>I know there is also the ArcSDESQLExecute class, but I would prefer not to use Geoprocessing in this case.</P> Fri, 22 Apr 2022 16:15:59 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-open-a-cursor-based-on-a-query-not-querydef/m-p/1167080#M8058 FridjofSchmidt 2022-04-22T16:15:59Z https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-open-a-cursor-based-on-a-query-not-querydef/m-p/1172876#M8123 <P>Found a solution based on the Database class instead of Geodatabase:</P><LI-CODE lang="csharp">var query = string.Format("select cast(forstgis.wimsidutil.nextwimsid({0}) " + "as number(38,0)) id from dual", unitId); using (var queryDesc = database.GetQueryDescription(query, "QueryLayer")) { queryDesc.SetObjectIDFields("id"); using (var table = database.OpenTable(queryDesc)) using (var cursor = table.Search()) { while (cursor.MoveNext()) { using (var row = cursor.Current) { return (int)row[0]; } } } }</LI-CODE> Wed, 11 May 2022 15:40:16 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/how-to-open-a-cursor-based-on-a-query-not-querydef/m-p/1172876#M8123 FridjofSchmidt 2022-05-11T15:40:16Z