AddFieldDelimiters

サマリー

Adds field delimiters to a field name for use in SQL queries.

レガシー:

This is a legacy function. Field delimiters are not needed for SQL queries in ArcGIS Pro.

構文

AddFieldDelimiters(datasource, field)

パラメーター	説明	データ タイプ
datasource	The data source used to determine the field delimiters.	String
field	The field name to which delimiters will be added. The field does not have to currently exist.	String

戻り値

データ タイプ	説明
String	The delimited field name.

コードのサンプル

AddFieldDelimiters example

import arcpy

field_name = arcpy.GetParameterAsText(0)
arcpy.env.workspace = arcpy.GetParameterAsText(1)
in_features = arcpy.GetParameterAsText(2)
out_feat_class = arcpy.GetParameterAsText(3)
state_value = arcpy.GetParameterAsText(4)

# AddFieldDelimiters will return a field name with the proper
# field delimiters for the workspace specified.
sql_exp = """{0} = '{1}'""".format(
    arcpy.AddFieldDelimiters('c:/data', field_name),
    state_value)

# Use delimited field for Select tool SQL expression
arcpy.analysis.Select(in_features, out_feat_class, sql_exp)

関連トピック

• Specify a query in Python