Interface IQueryDef
- Namespace
- ESRI.ArcGIS.Geodatabase
- Assembly
- ESRI.Server.Geodatabase.dll
Provides access to members that control attribute based queries.
[InterfaceType(ComInterfaceType.InterfaceIsIUnknown)]
[Guid("97103D51-3A9E-11D1-8816-0000F877762D")]
public interface IQueryDef
Remarks
The IQueryDef interface allows the definition of an attribute query based on one or more tables. Multiple table joins may be defined through the use of this interface.
In order to access the geometry of a feature returned by the query the shape field must be included in the SubFields definition.
If multiple feature classes are specified in the IQueryDef.Tables property it is the application developer's responsibility to ensure that only one shape attribute is specified in the IQueryDef.SubFields property.
public void IQueryDef__(IWorkspace workspace)
{
IFeatureWorkspace featureWorkspace = (IFeatureWorkspace)workspace;
IQueryDef queryDef = featureWorkspace.CreateQueryDef();
//Setting the SubFields, Tables, and WhereClause:
//Single table with a WhereClause
queryDef.Tables = "STATES";
queryDef.SubFields = "*";
queryDef.WhereClause = "STATE_NAME = 'California'";
//Multiple tables with a join.
queryDef.Tables = "STATES,STATEPOP,STATEAGE";
queryDef.SubFields = "*";
queryDef.WhereClause = "STATESID=POPID and POPID=AGEID";
//Using Evaluate:
ICursor cursor;
cursor = queryDef.Evaluate();
}
Properties
SubFields
The comma delimited list of field names for the query.
string SubFields { get; set; }
Property Value
Remarks
Format 1: "*"
This returns all fields on all tables. If duplicate column names are found, the field names will be prefixed with the table name (table.field_name).
Format 2: "field1,field2,field3"
Returns only the fields requested. (Separate field names by commas but do not add a space after or before the comma)
Format 3: "table1.*,table2.field1,table3.field2"
Returns all of the fields from table1, field1 from table2 and field 2 from table3.
Tables
The comma delimited list of table names for the query.
string Tables { get; set; }
Property Value
Remarks
WhereClause
The where clause for the query.
string WhereClause { get; set; }
Property Value
Remarks
For more information about where clauses, see IQueryFilter.WhereClause.
Methods
Evaluate()
Evaluate the query and return a cursor on the result set.
ICursor Evaluate()
Returns
Remarks
The IQueryDef interface is used to set up and define the query and also provides an Evaluate method that is used to execute the query, returning a cursor.