Database agnostic query syntax please

296
0
06-20-2013 01:37 PM
Status: Open
Labels (1)
mattwilkie
Occasional Contributor III

this has to have been discussed before, but I can't find it so here goes:

Can we please have a query syntax that is database agnostic?

I don't want to have to change all our definition queries and the like when migrating feature layers from ArcGIS Desktop to ArcGIS Server or ArcGIS Online, and then do it again when coming back the other way.

Esri Customer Service and I recently spent over 4 weeks troubleshooting an obscure error message (the specifed column does not exist), only to find it was because a File Geodatabase and ArcGIS Online use different syntax for date queries.

Wouldn't it be nice of the 1600 words in SQL reference for query expressions used in ArcGIS devoted to describing the differences in syntax could be collapsed to a single concise reference of perhaps 500 words?