amyjane28

Select by Attribute and Calculate from old AML

Discussion created by amyjane28 on Jun 19, 2013
Latest reply on Jun 19, 2013 by curtvprice
Hello,

I am not a person who works with Python but I am trying to convert an old AML into Python. Right now I am going line by line in the command prompt to see what works and then save that to a file.  What i need to do is a simple select by attribute and calculate an item based on the selected set. Is there no straight forward way to do this?  I am in v 10.1 if that matters.

the original AML querry and calc was simple
Select: [P] >= 30 AND (( [PF] is null ) AND  ( [MC] = 300 ))
Calc: [PF] = 'Char'


To attempt to duplicate this in Python, I've done the following:

import arcpy
FPlan = "C:\\path\<mine>.mdb\\FP
arcpy.MakeFeatureLayer_management = (FPlan, "F")
arcpy.SelectLayerByAttribute_management ("F", "NEW_SELECTION", " [P] >= 30 AND ( [PF] = '' AND [MC] = 300) ")
- I think this is selecting items, all it returns is <Result 'F'>

arcpy.CalculateField_management(calcF, "P", "Char")
-and this statement errors out.


Please, can anyone tell me how to determin if A) features are selected and B) how to correctly calc the selected set into the
item [P].

Thank you very much!
Amy

Outcomes