PROBLÈME
l’exécution d’une requête SQL avec une instruction SQL non valide dans ArcGIS Pro SDK renvoie une erreur de requête
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 ou alternative
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").ID d’article:000015910
Obtenir de l’aide auprès des experts ArcGIS
Télécharger l’application Esri Support
Informations associées
En savoir plus sur ce sujet
Search for related information
Find training related to this topic
Explore ideas and give feedback