This is a .NET project and I am building a query definition and tried using 'TOP' in the PrefixClause, but it generates an error 'Invalid parameter value passed to function'. This is what my code looks like:
Dim queryFilterDef As IQueryDef2 = CType(_featureWorkspace.CreateQueryDef, IQueryDef2) With queryFilterDef .WhereClause = searchString .PrefixClause = "TOP 1 " & featureClass.OIDFieldName End With Can TOP be used, and if so, what is the syntax? My objective is just to determine that there is at least one record - I do not want records returned, or at least no more than one record.
I am using ArcSDE/sql express right now. We also have some data in a file geodatabase where I have the same needs.
TOP will not work with File Geodatabase as it's not part of the current SQL implementation. In preliminary testing using top as PrefixClause does not appear to work for SQL Server. I need to do some more testing to see if it's a bug.
You could just use IFeature.FeatureCount to see is any rows will be returned by your query.
Thanks for the response! I don't want the number of records in the table, I want to know if any records exist with the search criteria that is entered. For example, I want to know if there are any businesses with a name like '% RIVER%'. I don't want how many records meet that criteria, I just want to know if at least one record meets that criteria.
I am using ArcSDE/sql express right now. We also have some data in a file geodatabase where I have the same needs.
TOP will not work with File Geodatabase as it's not part of the current SQL implementation. In preliminary testing using top as PrefixClause does not appear to work for SQL Server. I need to do some more testing to see if it's a bug.
You could just use IFeature.FeatureCount to see is any rows will be returned by your query.
