Be The First To Get Support Updates
Want to know about the latest technical content and software updates?

Problem: Running a SQL query with an invalid SQL statement in ArcGIS Pro SDK returns an query error


In ArcGIS Pro SDK, when attempting to perform a SQL query with an invalid SQL statement, the following error is returned:

Query Error: An invalid SQL statement was used.


The 1.4 version of Esri's Github Community samples for ArcGIS Pro SDK use the new C# 6 features that are available with Visual Studio 2015. For example, the interpolated string ($), such as in the following sample: Filter features based on attributes within an extent.
Line 143 of the Dockpane1ViewModel.cs has the following ling of code:

var whereClause = $"{SelectedField} = {quote}{FieldValue}{quote}";
Notice the use of the string interpolation operator (the dollar sign, $). This operator is only supported in Visual Studio 2015 and later. Attempting to use it in Visual Studio 2013 results in a compile error. Deleting it removes the compile error, but on running the code, a runtime error is returned.
Query Error: An invalid SQL statement was used

Solution or Workaround

The solution to this problem is to either hard-code the values for the string manually using supported features of Visual Studio 2013, or to upgrade Visual Studio to version 2015 to take advantage of the new C# 6 features, such as the interpolated string ($). For more information on the interpolated string, see the following post, Stack Overflow: What's with the dollar sign ($"string").

Related Information

Last Published: 1/27/2023

Article ID: 000015910

Software: ArcGIS Pro SDK (.NET) 3.0, 2.9, 2.8, 2.7, 2.6, 2.5, 2.4, 2.3, 2.2, 2.1, 2.0, 1.4, 1.3, 1.2, 1.1