January 15, 2007 at 2:04 pm
Hi all,
we have a situation on our project where we need to present to the user plans of builds, where the user can select a certain area (i.e. room, or hall-way) and mark some information on it.
What I think we need to do, is to store the points for each shape on the plan, for example a square room, we need to store each of the four points. How would I do this, and how would I be able to link the points together so that the correct shape is drawn.
So basically, I know I need to store the data as shapes and record their points (i think). I just need some pointers on how to store shaped data to be placed on maps/plans.
Look forward to hearing your ideas.
Thanks
Tryst
January 18, 2007 at 8:00 am
This was removed by the editor as SPAM
January 19, 2007 at 1:11 am
First thing I'd do, if you really want to do this in sql server, is upgrade to 2005 where you can define a user defined data type as an array , e.g. a box, a room, a cube etc. You do this via the CLR btw. seen it done and it works well.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 24, 2007 at 2:49 am
Right, thats interesting.
We already us SQL Server 2005, so will look into it.
But I worked for a company in the past who used SQL Server 2000 and they had a shapes table, shape category and I think there was some other table. And the draw of shapes could be drawn from the information contained in these tables.
Tryst
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply