Debugging ArcPy ERROR 000358: Invalid expression?

Question

I've tried several iterations of this SQL statement in a stand alone script:

    QF5 = "Week"
    QF6 = "Wk"
    RV3 = ""
    WC4 = """" {} <> {} AND {} <> '{}' """.format(QF5,QF6,QF6, RV3)

I'm aiming for an expression that would read int he field calculator:

Select From(*) Table Where:
Week <> Wk AND Wk <> ''

This is the error I'm getting:

ERROR 000358: Invalid expression
Failed to execute (SelectLayerByAttribute)

Your SQL is not correct: Select * From [Table] Where Week <> Wk AND Wk <> '' — Brad, Commented Oct 27, 2016 at 19:47
Right, sorry I was just guessing the first part of the query from the field calculator. That bit is not being expressed int the script. — geoJshaun, Commented Oct 27, 2016 at 20:30

Bjorn · Accepted Answer · 2016-10-27 20:05:28Z

2

This should work: WC4 = """{0} <> {1} AND {1} <> ''""".format(QF5,QF6) Your double quotes were unbalanced, and you don't need RV3.

answered Oct 27, 2016 at 20:05

Bjorn

2,60915 silver badges22 bronze badges

Add a comment |

1 Answer 1