I have this query:

code

options coordsys("Parcel Boundaries" as component);

select [Parcel_No],[ID], linepoint(Geom([ID]),[Length (I)]/2,"m") as [Geom]

from [Parcel Boundaries];

And I'm trying to link a drawing to it using it's geom column, but when I go to link the drawing, I get this error:

"Can't add object"

What could cause this?

The query itself runs fine.

Phish reunion - March 6, 7, 8, Hampton, Virginia.

Could you post the MAP file? The query seems OK.

sorry, I cannot post the map file because it contains licenced data.

But I noticed in the history pane that whenever I tried linking the drawing, it said "Invalid or missing metric for ID...". I kept deleting each record that had invalid or missing metric until I realized there were too many to delete. I then just deleted all line segments that were less than 1 metre in length, and the drawing then linked fine.

Phish reunion - March 6, 7, 8, Hampton, Virginia.

I can not reproduce the problem. Could you make a copy of your MAP file, reduce the original drawing to just one of the lines that is causing problems (less than 1 meter), replace any sensitive data in the fields of that line with random characters, and post that?

I discovered this problem was caused by "zero" length lines in the Parcel_Boundaries drawing. Once these zero lingth lines were removed, the query and linked drawing worked fine.

Phish reunion - March 6, 7, 8, Hampton, Virginia.