Modelbuilder: How to select items from a tabular table base upon a field from another layer
Same error even using the dummy up make table query.
I even tried a perpared mdb with all the tables having an OID. Same error!
BTW -- I am on 10.2.2 Don't know why the script did not work. I ran it in idle using the same DB I sent you, I even went as far as creating the same temp locations.... Still the same error. Re-created the Geodatabase ... with OID's (Esri recognized!) Still the same error. Harolds tool -- the MS Access is a personal geodatabase -- however the sign panels are a link to another base pure data. But the test I am doing for automation, it is not a link but a real table with OID's..... This project was to try and acomplish 100% automation for creating a field datase for GIS collection. The techs that would run it have little to no DB/GIS experience -- basically Facebooker's !
I am not a lover of Python because of the reasons I am experiencing -- very temperamental and inconsistant compared to VBA or VB.Net --- there I could trap problems/ repeat them etc.... Seems like I am taking a sledge hammer to perform a very basic sql query .... in any event I got another methodology to work using Select LayerByAttribute_management and building the select clause.
I still would be interested in figuring out why both Blake and Bruce script/tool was failing (for competeness sake!)
The Script I got to work in my model and my ESRI setup 
:
import arcpy, os # Local Variables OriginTable = arcpy.GetParameterAsText(0) #Sign Support --> Make Table View DestinationTable = arcpy.GetParameterAsText(1) #Sign Panels ---> Make Table View PrimaryKeyField = arcpy.GetParameterAsText(2) #SupportID /Sign Support ForiegnKeyField = arcpy.GetParameterAsText(3) #SupportID /Sign Panels def buildWhereClauseFromList(OriginTable, PrimaryKeyField, valueList): """Takes a list of values and constructs a SQL WHERE clause to select those values within a given PrimaryKeyField and OriginTable.""" fieldDelimited = arcpy.AddFieldDelimiters(arcpy.Describe(OriginTable).path, PrimaryKeyField) # Determine field type fieldType = arcpy.ListFields(OriginTable, PrimaryKeyField)[0].type # Add DBMS-specific field delimiters # Add single-quotes for string field values if str(fieldType) == 'String': valueList = ["'%s'" % value for value in valueList] # Format WHERE clause in the form of an IN statement whereClause = "%s IN(%s)" % (fieldDelimited, ', '.join(map(str, valueList))) arcpy.AddMessage(whereClause) return whereClause def selectRelatedRecords(OriginTable, DestinationTable, PrimaryKeyField, ForiegnKeyField): """Defines the record selection from the record selection of the OriginTable and apply it to the DestinationTable using a SQL WHERE clause built in the previous definition""" # Set the SearchCursor to look through the selection of the OriginTable sourceIDs = set([row[0] for row in arcpy.da.SearchCursor(OriginTable, PrimaryKeyField)]) # Establishes the where clause used to select records from DestinationTable whereClause = buildWhereClauseFromList(DestinationTable, ForiegnKeyField, sourceIDs) # Process: Select Layer By Attribute arcpy.SelectLayerByAttribute_management(DestinationTable, "NEW_SELECTION", whereClause) # Process: Select related records between OriginTable and DestinationTable selectRelatedRecords(OriginTable, DestinationTable, PrimaryKeyField, ForiegnKeyField) #output same as Destination Table
