topic Re: Automation Exception while using the order by clause with the query filter in Java Maps SDK Questions

Automation Exception while using the order by clause with the query filter

pavan_kumarmuttigi — Tue, 11 Jun 2013 10:02:51 GMT

Hi,

Can any one please help me in resolving the issue with the query filter which I am getting when trying the query with order by clause.
BTW, I am working using the ArcObjects API for Java.

I am getting the following Automation Exception: Item Not Found in this Collection.

I am using the query to the queryfilter like as follows.

String query = ST_ID in (234,456) order by ST_ID asc

IQueryFilter queryFilter = new QueryFilter();
queryFilter.setWhereClause(query);

I am getting the above mentioned AutomationException.Can anyone please help me in resolving the issue?
Actually I do have a doubt like does the order by clause is supported in ArcObjects?

Thanks in Advance

Re: Automation Exception while using the order by clause with the query filter

CarlosColón-Maldonado — Wed, 12 Jun 2013 03:26:34 GMT

Well, I don't think you'll find an answer on this forum. The API's are not compatible or interchangeable. I noticed you've already posted the question on the right forum and gotten no answers, yet.

Did you look at this post on the ArcObjects SDKs forum? This post also mentions the use of the String.Format method to avoid concatenation complexities.

Good luck!

Re: Automation Exception while using the order by clause with the query filter

pavan_kumarmuttigi — Wed, 12 Jun 2013 06:45:14 GMT

Hi Carlos Colón-Maldonado,

Thanks a lot for your help.