English

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

Description

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.

Cause

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