topic Query Table Error in ArcGIS Pro SDK Questions

Query Table Error

tzz_12 — Thu, 29 Sep 2022 19:05:58 GMT

I am wondering how I can fix this WhereClause? Everything seems to work, except for the query. Thanks for your help!

QueuedTask.Run(() =>
{
string mKey = "462409";

var ckeys = new string[3] { "19605542","19605543","19605707" };

using (Geodatabase geodatabase = new Geodatabase(new FileGeodatabaseConnectionPath(new Uri(inPath))))

using (var HzTable = geodatabase.OpenDataset<Table>("TableName"))
{
foreach (var Ckey in ckeyList)
{
QueryFilter qf = new QueryFilter()
{
WhereClause = $@"ckey = {Ckey}",

};

using (var rowCursor = HzTable.Search(qf)) //error here
{
while (rowCursor.MoveNext())
{
using (Row row = rowCursor.Current)
{

Calculations performed here...etc.

Re: Query Table Error

KenBuja — Thu, 29 Sep 2022 19:24:17 GMT

If you're filtering on a string field, you need to enclose the variable in quotes

WhereClause = $@"ckey = '{Ckey}'",

Re: Query Table Error

Wolf — Thu, 29 Sep 2022 23:19:08 GMT

Depending on the datatype of ckey field you might have to change your syntax so that:

WhereClause = $@"ckey = {Ckey}",

could turn into this:

WhereClause = $@"ckey = '{Ckey}'",

Needless to say the field 'ckey' must exists in the table "TableName"