How to create shape incidences on a drawing based on database reco

[Steve Won]

I want to create a drawing with shapes by specifying their incidences in a
database. For example, I have a floorplan of a room in the background of a
Visio document. I want to generate some shapes (e.g. a rectangle and a
square) by importing database records that specify where and how the shapes
are in the floor plan. This allows me to generate the drawing of those shapes
in a room.

It seems to be something to do with Linking shapes with Database, but I am
not sure. Could someone share some insights? Thank you

 

[Al Edlund]

you might check this out for some basics on mixing access and visio.
http://msdn.microsoft.com/archive/d...en-us/dnarvisio/html/facilitiesmanagement.asp
al

 

[Steve Won]

Thank you, Al.

What I find is that the database is updated by the move of shapes in the
drawing. It seems that I may make use of the other way round - changing the
database to initiate a change in the drawing.

Steve

 

[Al Edlund]

It seems that I may make use of the other way round - changing the

database to initiate a change in the drawing.

For that type of an objective you have to capture the shape changed event
(either through a formula changed or cell changed) and use it to trigger an
update transaction to the database. Is your challange the capturing of the
event or the sql transaction?

al

 

[Steve Won]

Thanks again.

Actually, I am challenged by both the capturing and the sql transaction.
Are there other links I can get more info on these two areas? Thanks

Steve

 

[Al Edlund]

the visio sdk (available on msdn for free) has numerous examples of
capturing events for shapes. writing ado(.net) code is probably out of
scope for this forum, but you might start over here

http://msdn.microsoft.com/library/d...y/en-us/vbcon98/html/vbcondataaccessguide.asp

al

 

[Steve Won]

Many many thanks.

the visio sdk (available on msdn for free) has numerous examples of
capturing events for shapes. writing ado(.net) code is probably out of
scope for this forum, but you might start over here

http://msdn.microsoft.com/library/d...y/en-us/vbcon98/html/vbcondataaccessguide.asp

al