Is This Content Helpful?
We're glad to know this article was helpful.
When executing a WHERE clause, one of the following error messages is returned:
“There was an error executing the query.
An invalid SQL statement was used.
An invalid SQL statement was used. [NameOfTable]
An invalid SQL statement was used. [<SQL expression>]".
"Run-time error ‘-2147220985 (80040207)’:
The owner SID on a per-user subscription doesn’t exist".
This error can occur when all of the following conditions are met:
This problem does not occur in personal or ArcSDE geodatabases, so a workaround is to copy the feature class or table into one of these geodatabases and execute the query against the data there.
Changing the decimal point to a comma is not a workaround for this problem, and as always, it is still regarded as invalid SQL syntax. For example, the following Where clause does not work:
WhereClause = "ph = 6,6"