topic Re: Geodatabase.Evaluate throw not implemented exception in ArcGIS Pro SDK Questions

Geodatabase.Evaluate throw not implemented exception

JinZ — Thu, 05 Jan 2023 15:54:59 GMT

Hi,

I am trying to execute a query on sql database.I am using ArcgisPro ,Net SDK. I followed the example on the documentation. However I got the method is not implemented exception.

Is this method really not implemented? or did I miss something.

Thanks much for help.

Here is my code:

using Geodatabase geodatabase = new Geodatabase(connectionProperties);
// Use the geodatabase
QueryDef getMapListQueryDef = new QueryDef
{
SubFields = "FMB4_LatestWellStatusPackageProduct.Name,T_Well.Latitude, T_Well.Longitude, T_WELL.EPSG_NO",
Tables = "FMB4_LatestWellStatusPackageProduct,T_Well ,FMB_Product ",
WhereClause = "FMB4_LatestWellStatusPackageProduct.Well_ID=T_Well.ID AND FMB4_LatestWellStatusPackageProduct.ProductID=FMB_Product.ID AND[FMB4_LatestWellStatusPackageProduct.R_WELL_STATUS_ID <> 210 AND FMB_Product.Name ='" + fmbProduct+"'",
};

using (RowCursor rowCursor = geodatabase.Evaluate(getMapListQueryDef, false))
{
while (rowCursor.MoveNext())
{
using (Row row = rowCursor.Current)
{
string wellname = Convert.ToString(row["Name"]);
codeList.Add(wellname);
}
}
}

Re: Geodatabase.Evaluate throw not implemented exception

MatthewDriscoll — Thu, 05 Jan 2023 16:05:23 GMT

Try using table search and QueryFilter instead.

using (var tbl = featLayer.GetTable()).....

var queryFilter = new QueryFilter
{...

using (var rowCursor = tbl.Search(queryFilter, false))....

Re: Geodatabase.Evaluate throw not implemented exception

KenBuja — Thu, 05 Jan 2023 16:04:51 GMT

Is your WhereClause causing the problem? There's a bracket instead of a space

AND[FMB4_LatestWellStatusPackageProduct.R_WELL_STATUS_ID

Re: Geodatabase.Evaluate throw not implemented exception

KenBuja — Thu, 05 Jan 2023 16:13:32 GMT

The example uses a QueryDef

Re: Geodatabase.Evaluate throw not implemented exception

MatthewDriscoll — Thu, 05 Jan 2023 16:17:18 GMT

Understood. I was having similar problems getting QueryDef and Evaluate to work and found using QueryFilter and Search was able to accomplish the same goal.

Re: Geodatabase.Evaluate throw not implemented exception

JinZ — Thu, 05 Jan 2023 17:01:29 GMT

The table search and QueryFilter works for one table only? How to query more than one table?

Re: Geodatabase.Evaluate throw not implemented exception

RichRuh — Thu, 05 Jan 2023 17:04:16 GMT

I would start by fixing the syntax error, as pointed out by @KenBuja. I suspect the problem here is a bad error message.

What kind of database is this?

--Rich

Re: Geodatabase.Evaluate throw not implemented exception

JinZ — Thu, 05 Jan 2023 17:04:17 GMT

Thanks! that is a typo. I corrected it and tried again, still got the same exception message: The method or operation is not implemented.

Re: Geodatabase.Evaluate throw not implemented exception

JinZ — Thu, 05 Jan 2023 17:09:52 GMT

it's a sql database. after fixed the syntax error, still got the same error.

Re: Geodatabase.Evaluate throw not implemented exception

RichRuh — Thu, 05 Jan 2023 17:16:04 GMT

SQL Server, Oracle, Postgres, etc. are all sql databases. Which one are you using?