PROBLEM
Beim Ausführen einer SQL-Abfrage mit einer ungültigen SQL-Anweisung im ArcGIS Pro SDK wird ein Abfragefehler zurückgegeben
Beschreibung
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.
Ursache
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
Lösung oder Problemumgehung
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").Artikel-ID:000015910
Hilfe von ArcGIS-Expert*innen erhalten
Die Esri Support-App herunterladen
Zugehörige Informationen
Weitere Informationen zu diesem Thema erkunden
Search for related information
Find training related to this topic
Explore ideas and give feedback