An SQL expression used to select a subset of features by attributes. The syntax for the expression is slightly different, based on the data you're querying.
If you're querying ArcInfo coverages, shapefiles, INFO tables, or dBASE tables, field names must be enclosed in double quotes in the SQL expression: "MY_FIELD". If you're querying personal geodatabase data, enclose fields in square brackets: [MY_FIELD]. If you're querying ArcSDE geodatabase data or data in an ArcIMS feature class or ArcIMS image service sublayer, don't enclose fields: MY_FIELD. Personal geodatabase uses '*' and '?' as string wild cards rather than the '%' and '_' used by all other formats. Personal geodatabase - '[CNTRY_NAME] = 'Canada'' If you're querying file based or multiuser geodatabase data - "'CNTRY_NAME' = 'USA'" or '"CNTRY_NAME" = \'USA\'' (In, Optional)
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property where_clause As Object |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As Select
Dim value As Object
instance.where_clause = value
value = instance.where_clause |
| C# | |
|---|
public object where_clause {get; set;} |
Requirements
Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family
See Also
