AnsweredAssumed Answered

SQL error when using Python call argument

Question asked by bobm007 on Mar 7, 2013
Latest reply on Mar 7, 2013 by bobm007
Hi,

The following code add two arguments to the Python call. The first argument works fine but the second gives an invalid SQL error when using SELECT. The script I have attached shows the parcel string hard coded to a Parcels variable, this works OK. Can someone provide the correct string for strParcels? Note the \\ is meant to relate to a \ in the final SQL

    strOwner = "Lett"
    strParcels = "PARCEL_SPI = '1\\TP8994'"

retVal = Shell("cmd.exe /K S:\MID_Owners_Database_Workspace\OwnerProperty.py " & strOwner & " " & strParcels, 1)

Attachments

Outcomes