Use Python to set definition query in Pro issue

ScoutStanley

Hi, 

I am trying to set up definition query in Pro. Purpose of the script is that it loops through table and creates new map based on the row value. However, I can't get my definition query to work. If I specify a specific pin number  such as "DGCO.GIS_OWNER.ParcelQueue.JOINPIN = 56" the script will work fine, but I am needing to run through multiple row values, so the script will crash after "row number 56". Any ideas on how to get definition query to work through loop?

#Set definition query on Parcels using PIN
        for lyr in m.listLayers("Parcel*"):
            if lyr.supports("DefinitionQuery"):
                lyr.definitionQuery = "DGCO.GIS_OWNER.ParcelQueue.JOINPIN = " + PIN

Below is PIN defined, which works and pulls the correct row value. However, my definition query above won't recognize it. 

PIN = i.getValue(SearchField)

blake.terhune

I highly recommend levering string literals in Python with f""

PEP 498 – Literal String Interpolation | peps.python.org

lyr.definitionQuery = f"DGCO.GIS_OWNER.ParcelQueue.JOINPIN = '{PIN}'"