none
Spatial Results Tab window not showing up in Microsoft Visual studio(SSDT) RRS feed

  • Question

  • I cannot see the 'spatial results' tab window when i execute the query below.When i run a normal query i can see 2 tabs showing 'results' and 'message' but not the 'spatial results' tab. I am using Microsoft visual studio2017(ssdt).The codes below works fine but it displays the columns as text and coordinates but not in a grid format.Can someone tell me how to get the spatial results tab.Is there something that i need to download.Please advise.

    Create table [Spatialinfo]
    (id INT,spatialdata geometry,shape Varchar(10));
    
    INSERT INTO [spatialinfo]
    (spatialdata)
    VALUES ('Point(7 12)');
    
    Select * From Spatialinfo;

    The result that i get is something approximately as follows in the message window. Please note that i have set the output to be displayed as a grid and not text but still i cant get the spatial results window to appear.

    id       spatialdata                          shape
    1        0x000010c0000022400000002840         null

    As you can see the spatial results tab is missing and not showing the grid lines.

    Can someone tell me what i have missed in the above descriptions.

    regards

    mark


    mark

    Monday, July 8, 2019 11:30 AM