I have query that I have modified from Art's post over on gisadvising The intent of the query is to clip interesect two drawing components.
I've run into behaviour that I've not seen before, in that the query will run with no other user interaction in the following conditions:
I mouse over and single click on the query;
I mouse over and double click on the query;
I save the map, the query runs after I click save;
I cut and paste the query text into a new query.
Both the query and the Manifold instance have a * character appended to the map/query name in the window headers.
I cannot open the query component in the project pane by double clicking it, as the query runs.
I've tried importing the two drawing components (PV and EVD) into a new mfd instance, then copying the query text via notepad into a new query component. The behaviour is the same.
(SELECT ClipIntersect([PV].[Geom (I)],[EVD].[Geom (I)]) AS g,
WHERE g IS NOT NULL
GROUP BY NAME