That'd make sense if it weren't for the fact that I've since been working w/the other script you pointed me to that doesn't use that whereClause. And again, it bombs out on NER. here's a portion of what I've been working on:
# Process: Select Layer By Attribute to pre-select records in catalogTable where REG_CODE = <input>
arcpy.SelectLayerByAttribute_management(catalogTable, selOption, sqlExp)
# Environment
arcpy.env.qualifiedFieldNames = False
# Get the set of selected OIDs in the input
desc = arcpy.Describe(linkTable)
fidSet = desc.FIDSet
if fidSet:
fidList = fidSet.replace(' ','').split(';')
oidSet = set([int(oid) for oid in fidList])
else:
oidSet = set()
# Get a set of key values
arcpy.AddMessage('Finding unique key field values...\n')
keyValues = set([row[0] for row in arcpy.da.SearchCursor(catalogTable,"CR_ID")])
# Extract all candidate target OIDs and their key field values
# We operate on this set for later selection on ObjectID
arcpy.AddMessage('Finding input table ObjectID and key field mapping...\n')
sourcePath = os.path.join(desc.path,desc.name)
tmpView = "tmpView"
arcpy.MakeTableView_management(sourcePath,tmpView)
oidKVDict = {row[0]:row[1] for row in arcpy.da.SearchCursor(tmpView,
['OID@',"CR_ID"])}
#oidKVList = [(k, v) for (k, v) in oidKVDict.items()]
oidKVList = [(k, v) for (k, v) in list(oidKVDict.items())]
allSet = set([t[0] for t in oidKVList])
# Find OID values to select on
arcpy.AddMessage('Finding selection set...\n')
if selOption == 'NEW_SELECTION': # Adopt value set
oidList = sorted([t[0] for t in oidKVList if t[1] in keyValues])
elif selOption == 'ADD_TO_SELECTION': # Add value set
addSet = set([t[0] for t in oidKVList if t[1] in keyValues])
oidSet |= addSet
oidList = sorted(list(oidSet))
elif selOption == 'REMOVE_FROM_SELECTION': # Common values removed
remSet = set([t[0] for t in oidKVList if t[1] in keyValues and t[0] in oidSet])
oidSet -= remSet
oidList = sorted(list(oidSet))
elif selOption == 'SUBSET_SELECTION': # Common values retained
andSet = set([t[0] for t in oidKVList if t[1] in keyValues])
oidSet &= andSet
oidList = sorted(list(oidSet))
else:
arcpy.AddError('Unknown selection option\n')
sys.exit(0)
# Make the selection
arcpy.AddMessage('Selecting...\n')
compOIDList = sorted(list(allSet - set(oidList)))
if len(compOIDList) == 0: # select all
whereClause = '{} is not null'.format(desc.OIDFieldName)
elif len(oidList) == 0: # select none
whereClause = '{} < 0'.format(desc.OIDFieldName)
elif len(oidList) <= len(compOIDList):
inStatement = repr(tuple(oidList)).replace(',)',')')
whereClause = '{} in {}'.format(desc.OIDFieldName,inStatement)
else:
inStatement = repr(tuple(compOIDList)).replace(',)',')')
whereClause = '{} not in {}'.format(desc.OIDFieldName,inStatement)
arcpy.SelectLayerByAttribute_management(linkTable,'NEW_SELECTION',whereClause)
#arcpy.SetParameter(5,linkTable)
arcpy.Delete_management(tmpView)
