It would be helpful if we could use the SQL Expression Builder in the Create Database View geoprocessing tool.
Source: @AlfredBaldenweck 's comment in Improve SQL Expression BuilderThe weird thing is that the implementation of various [SQL Expression] features we want is all over the place. We have them in some workflows but not others....Creating a view? Good luck. You gotta know your datasets very well before you can successfully write the query.
Source: @AlfredBaldenweck 's comment in Improve SQL Expression Builder
The weird thing is that the implementation of various [SQL Expression] features we want is all over the place. We have them in some workflows but not others.
...Creating a view? Good luck. You gotta know your datasets very well before you can successfully write the query.
Related: Consistent .exp SQL expression loading/parsing in GP tools
Hard agree, whoever originally said that is a genius (hahahaha).
Having some sort of expression builder, as well as a validator, would be awesome.
The current method of "write your query and then see if fails halfway through" is... suboptimal.
agree! building a definition query will give you clues as to errors in your script but absolutely none for this tool.
Meld je aan om te posten, content te volgen en meer. Nieuw hier? Registreer gratis.
