https://community.esri.com/t5/arcgis-pro-sdk-questions/get-numbers-from-a-geodatabase-sequence-using-pro/m-p/1543694#M12134 <P>Hi,</P> <P>Assuming you want to get NEXTVAL from a DBMS sequence, you could:</P> <P>Create a DatabaseClient object then call ExecuteStatement with the sql string via the Pro API.<BR />You would have to write into a temp table then read from that table to get the value. Messy.</P> <P>Use SqlCommand and SqlDataReader within .net<BR /><A href="https://stackoverflow.com/questions/21709305/how-to-directly-execute-sql-query-in-c" target="_self">https://stackoverflow.com/questions/21709305/how-to-directly-execute-sql-query-in-c</A></P> Mon, 30 Sep 2024 02:16:57 GMT sjones_esriau 2024-09-30T02:16:57Z https://community.esri.com/t5/arcgis-pro-sdk-questions/get-numbers-from-a-geodatabase-sequence-using-pro/m-p/1543572#M12130 <P>I would like to return numbers from a geodatabase sequence using Pro SDK. I have searched the SDK reference and could not find anything. Can anyone confirm that at this time geodatabase sequences can only be queried via attribute rules? If that is the case, will future releases of Pro SDK support this functionality? Thanks!</P> Fri, 27 Sep 2024 20:42:42 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/get-numbers-from-a-geodatabase-sequence-using-pro/m-p/1543572#M12130 azlotin 2024-09-27T20:42:42Z https://community.esri.com/t5/arcgis-pro-sdk-questions/get-numbers-from-a-geodatabase-sequence-using-pro/m-p/1543694#M12134 <P>Hi,</P> <P>Assuming you want to get NEXTVAL from a DBMS sequence, you could:</P> <P>Create a DatabaseClient object then call ExecuteStatement with the sql string via the Pro API.<BR />You would have to write into a temp table then read from that table to get the value. Messy.</P> <P>Use SqlCommand and SqlDataReader within .net<BR /><A href="https://stackoverflow.com/questions/21709305/how-to-directly-execute-sql-query-in-c" target="_self">https://stackoverflow.com/questions/21709305/how-to-directly-execute-sql-query-in-c</A></P> Mon, 30 Sep 2024 02:16:57 GMT https://community.esri.com/t5/arcgis-pro-sdk-questions/get-numbers-from-a-geodatabase-sequence-using-pro/m-p/1543694#M12134 sjones_esriau 2024-09-30T02:16:57Z