Toad World® Forums

Intellisense question


#1

In the below statements how can I bring up the intellisense in the second select statement. When I place the cursor in the space after the SELECT and press nothing happens. Is this the expected behavior?

thx.

DECLARE @g GEOGRAPHY

SET @g = (SELECT LL FROM spatial_NTS_250 WHERE Mapsheet = ‘072E’)
–SELECT @G

SELECT XY_Polygon.STCentroid().STX AS X, XY_Polygon.STCentroid().STY AS Y, 0 AS ‘z’, LSD, Section, Township, Range, Meridian FROM spatial_ATS WHERE LL_Polygon.STIntersects(@g)=1 AND (LSD IS NOT NULL) AND (SECTION IS NOT NULL)


#2

It seems to work fine when we try it here:

/Mauritz
image001.jpeg