What are the challenges you face when working across database platforms? Take the survey
Options

Suggestions stop working after line in code

0101101001011010 Posts: 10 Bronze 2
edited April 4, 2019 7:02PM in SQL Prompt
Spatial not all there yet.

sqlprompt stops providing suggestions after this line of code, where @XYOrigin is a Geometry Type.
UPDATE @tWell SET EastingExaggerated = (@XYOrigin.STX + (@XYOrigin.STDistance(XY) / @VerticalExaggeration)) WHERE ListOrdinal <> 0
if @XYOrigin.STX is changed to value (10) suggestions resume after this point. As one would expect.

Spatial still appears to be an issue with sqlprompt, getting better but still issues.
Sign In or Register to comment.