Access database properties from code

[GaryD]

I have Visio Pro 2003, and am using an Entity Relationship diagram for my
system's database design. I have written VBA macro code to iterate
through all the shapes on all the pages and spit out DDL (our proprietary
format). The problem I have is that I can only retrieve information from
the shapes' text, so I don't have access to properties such as the
required flag on columns, the PK name assigned, etc. Anyone have any
ideas or examples of how to get at that lower-level information?

Thanks,
Gary

 

[Mike Ishimitsu[MSFT]]

The website http://www.pdata.com/VME/VisioModelingEngine.htm may be able to provide the detail you are looking for.

--
Mike
Visual Studio Enterprise Frameworks and Tools

This posting is provided "AS IS" with no warranties, and confers no rights. Use of included script samples are subject to the terms
specified at http://www.microsoft.com/info/cpyright.htm

Note: For the benefit of the community-at-large, all responses to this message are best directed to the newsgroup/thread from which they
originated.
--------------------
From: "GaryD" <[email protected]>
Newsgroups: microsoft.public.visio.database.modeling
Subject: Access database properties from code
Date: Tue, 18 May 2004 12:48:14 -0400

I have Visio Pro 2003, and am using an Entity Relationship diagram for my
system's database design. I have written VBA macro code to iterate
through all the shapes on all the pages and spit out DDL (our proprietary
format). The problem I have is that I can only retrieve information from
the shapes' text, so I don't have access to properties such as the
required flag on columns, the PK name assigned, etc. Anyone have any
ideas or examples of how to get at that lower-level information?

Thanks,
Gary