Tim, From a bit of playing around with your suggestions, it looks like we can modify the geometry of an object in the table, but not the underlying projection of the drawing, which looks to be the same conclusion you have come to. For my way of thinking, this should be part of an ALTER TABLE statement, which Manifold does support, but I see no way to alter the geometry column things like coordinate system. I'd love someone to prove me wrong, but from what I can see, the only way to alter the coordinate system of an existing drawing is to use through the object model. Having said this, though, the only thing you would have to do via scripting (object model) is to create the drawing and modify the coordinate system. Everything else could be controlled through insert sql. If you wanted to cheat a little, you could alter the default coordinate system that Manifold creates drawings to be what you are after. Bit of a hack, but might get you closer to what you are after. Changing tack, if you do want to control everything via SQL, have you thought about Postgresql? It has the ability to reproject via queries and has very powerful spatial sql abilities. It's a quality database, and perhaps best of all, is free. Manifold can also link to drawings in postgres and certainly in my case, I do most of my heavy lifting spatial sql in there. Sorry I can't be much help in what you are after Cheers James
James Kelly http://www.locationsolve.com |