Problème : L’exécution D’une Requête SQL Avec Une Instruction SQL Non Valide Dans ArcGIS p

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

Recevoir des notifications et trouver des solutions liées à de nouvelles questions ou à des problèmes connus

Recevez des réponses synthétisées et des solutions en vidéo de notre nouvel agent conversationnel (IA).

Télécharger l’application Esri Support

Informations associées

ArcGIS Pro SDK Community Sample: FilterFeaturesBasedOnAttributesWithinAnExtent
Stack Overflow: What's with the dollar sign ($"string")

En savoir plus sur ce sujet

Obtenir de l’aide auprès des experts ArcGIS

Contacter le support technique