I have run a spatial query listing points in areas - Query

SELECT [Areas].[TenID], [Points].[Hole ID]

FROM [MASTER AllHole Collar] as Points, [Tenements_Live Drawing All BRM Proposed S2R] as Areas

WHERE Contains ([Areas].[ID], [Points].[ID])

When the query results are returned, all points look like they are selected, however nothing is visible in Drawing View. (see attached jpg)

I would like to select specific items in the query result listing, and see them in the Drawing view. I believe I have been able to do this before, however don't seem to be able to nut it out this time.

I am running Win 10 and Manifold V8.0.35

Any help greatly appreciated. Many thanks

Attachments:
Image spatial Query Selection .jpg

Have you refreshed the drawing view after running the query?

Many thanks Dimitri. Appreciate your thoughts here.

I would think so, even though I dont really use the View / Refresh Data command. I have opened and reopened the drawing. Am I refreshing doing that? Actually Refresh Darta is greyed out presently? I see I have 'Auto refresh' selected.

No holes are selected, and no tenements are selected. I am trying to highlight subsets of the query output and see their distribution on the Master AllHole Collar drawing? Any further ideas very much appreciated.

With thanks

Just in case an example would assist in trying to identify my problem here. Any help greatly appreciated. Many thanks forum

Attachments:
Example Manifold spatial SQL.map

The object in the drawing do not get selected because you forgot to add the identity column in your query.

Try this:

-- SQL

SELECT [Areas].[ID], [Areas].[TenID], [Points].[Hole ID]

FROM [Collars] as Points, [Tenements] as Areas

WHERE Contains ([Areas].[ID], [Points].[ID])

Cheers,

Chris

http://www.mppng.nl/manifold/pointlabeler

Perfect. Many thanks Chris. Really appreciate it Yes!