topic Re: I need help in ArcObjects SDK Questions

I need help on this error message

OLANIYANOLAKUNLE — Tue, 07 Aug 2012 22:04:37 GMT

I need help on this error message
I was trying to write a custom python script for Definition query for a particular layer and this error message was what i got
NameError: name 'field' is not defined

after entering the following codes -
#Variables to form defintion query
field = '"Name_Allottee"'
value = "'Fadare A Adetoye'"
#concatenate query syntax
queryStr = "Name_Allottee" + "=" + "Fadare A Adetoye"
#Specify the MXD project (CURRENT), dataframe (Layers)
mxd = arcpy.mapping.MapDocument("CURRENT")
df = arcpy.mapping.ListDataFrames(mxd, "Layers")
#Apply defintion query to specified layer group (KWAGIS_Parcels)
for lyr in arcpy.mapping.ListLayers(mxd, "KWAGIS_Parcel", df):
if lyr.supports("DEFINITIONQUERY"):
lyr.definitionQuery = queryStr
arcpy.RefreshActiveView()

Re: I need help on this error message

BruceNielsen — Wed, 08 Aug 2012 18:04:03 GMT

Try this:

queryStr = "\"Name_Allottee\" = 'Fadare A Adetoye'"

In a query string, field names need to be enclosed in double quotes, and string values in single quotes.

Thanks i got it

OLANIYANOLAKUNLE — Thu, 09 Aug 2012 22:36:46 GMT

Do you have any python script that can clip the data frame extent to a selected feature, a script different from the clipping under the geoprocesssing tool?

Thanks a bunch

Re: I need help on this error message

OLANIYANOLAKUNLE — Thu, 09 Aug 2012 23:05:28 GMT

the Code:
queryStr = "\"Name_Allottee\" = 'Fadare A Adetoye'" seems not to work with my layer under a parcel fabric i.e. my layer is a parcel layer under a parcel fabric dataset and when i run dis definitionquery for the parcel layer it does not return any results, what would return a result is this sql statement - [Name_Allottee] = 'Fadare A Adetoye', how can i put this into my python script below and make it work?

import arcpy
import pythonaddins
import os

        mxd = arcpy.mapping.MapDocument("Current")
        df = arcpy.mapping.ListDataFrames(mxd)[0]
        lyr= arcpy.mapping.ListLayers(mxd,"Parcels")[0]
        lyr.definitionQuery = '"Name_Allot" =\'Fadare A Adetoye\''
        arcpy.RefreshTOC
        arcpy.RefreshActiveView

Thanks - what i want is how to concatenate the lyr.definitionquery for features in a geodatabase

Thanks i got it

OLANIYANOLAKUNLE — Sat, 11 Aug 2012 20:05:05 GMT

mxd = arcpy.mapping.MapDocument("Current")
        df = arcpy.mapping.ListDataFrames(mxd)[0]
        lyr= arcpy.mapping.ListLayers(mxd,"Parcels")[0]
        lyr.definitionQuery = '"Name_Allottee" =\'Fadara A Adatoyo\''
        arcpy.RefreshTOC()
        arcpy.RefreshActiveView()

Re: I need help

OLANIYANOLAKUNLE — Wed, 15 Aug 2012 23:19:01 GMT

i used the following python script to create a script tool to select an attribute of a particular feature, but it returns all the records of the feature specified in the FeatureClass;

import arcpy
arcpy.env.overwriteOutput = True

try:
    # Get the input parameters for the selection tool
    FeatureClass = arcpy.GetParameterAsText(0)
    SQLStatement = arcpy.GetParameterAsText(1)

    # Select by Layer Attribute
    arcpy.SelectLayerByAttribute_management(FeatureClass, "NEW_SELECTION", "")

    # Report a success message
    arcpy.AddMessage("All done!")

except:
    # Report an error messages
    arcpy.AddError("Could not complete the selection")

    # Report any error messages that the selection tool might have generated
    arcpy.AddMessage(arcpy.GetMessages())

Please any suggestions. Thanks

Re: I need help on this error message

BruceNielsen — Thu, 16 Aug 2012 12:05:43 GMT

A SelectLayerByAttribute statement without the query statement is like saying "SELECT ALL FROM...". Since you're accepting a SQL statement as a parameter, I believe you want something like this:

arcpy.SelectLayerByAttribute_management(FeatureClass, "NEW_SELECTION", SQLStatement)