When you publish a script GP tool it tries to "fix" the paths for me. I get that part. But it is also changing my query strings and I cannot figure out why or how to stop it.
I have tried all 3 of these ways
exp="PrimaryKey IN(" + terrapkString +" )")
exp = f'PrimaryKey IN({terrapkString})'
exp = "PrimaryKey IN({})".format(terrapkString)
arcpy.Append_management(tablePath, os.path.join(outGDB, table), expression=exp)
But the server keeps doing something like this. Changing it in two places
terrapkString = terrapkString + g_ESRI_variable_5 + pk + "',"
g_ESRI_variable_5 = "'"
g_ESRI_variable_6 = 'PrimaryKey IN({})'
g_ESRI_variable_7 = 'PrimaryKey IN('
g_ESRI_variable_8 = ' )'
exp = g_ESRI_variable_6.format(terrapkString)
I am out of options to try now I think. What is tripping it up here? It still works but I want to know which format it would like.
thanks a lot
