Database Diagram 'Entity' attributes/properties

[Vidas]

I am trying to dynamically build a Visio Database Model Diagram from VBA 6.
I can create ‘Entity’ objects but I cannot set entety object properties. Are
there anywhere theses properties documented?
Or maybe could someone put several sample code lines? For example, how to
set entity
physical name, attributes.

Vidas

 

[Vidas]

Maybe someone knows how to run sql script from VBA silently in database
model diagram.
Or is it hidden all information about made templates by Microsoft?

Vidas

 

[Bradford]

I went through exactly this a few weeks ago.. I was unable to find a way to assign properties to entities in a database diagram.. the closest I could get was to create a template using standard rectangles aligned and grouped similar to the entity object and then assign text to the rectangles. Visually it appears similar but you cannot use the diagram to forward engineer databases or anything.

What are you trying to do? If you just want to diagram a regular database the reverse engineer database function can build a database diagram from a database.

Bradfor


----- Vidas wrote: ----

I am trying to dynamically build a Visio Database Model Diagram from VBA 6
I can create ‘Entity’ objects but I cannot set entety object properties. Ar
there anywhere theses properties documented
Or maybe could someone put several sample code lines? For example, how t
set entit
physical name, attributes

Vida

 

[Vidas]

I need to build database model diagram from VB.

Vidas

I went through exactly this a few weeks ago.. I was unable to find a way

to assign properties to entities in a database diagram.. the closest I could
get was to create a template using standard rectangles aligned and grouped
similar to the entity object and then assign text to the rectangles.
Visually it appears similar but you cannot use the diagram to forward
engineer databases or anything..

What are you trying to do? If you just want to diagram a regular database

the reverse engineer database function can build a database diagram from a
database..

 

[Bradford]

Do you need to create an actual Visio ‘database diagram’ or just something that looks identical to a database diagram? I found a way to programmatically create diagrams in Visio which are visually identical to the database diagrams but they lack the behind the scenes functionality included in the real database diagrams

Bradfor

 

[Vidas]

I have made database model diagram which is visually identical to real one,
but i need to create real diagram, because i want to reuse visio forward
engineering.

Vidas

Do you need to create an actual Visio ‘database diagram’ or just something

that looks identical to a database diagram? I found a way to
programmatically create diagrams in Visio which are visually identical to
the database diagrams but they lack the behind the scenes functionality
included in the real database diagrams.

 

[Andrew]

Did you ever figure out a way to add columns to this shape. I tried addings rows and such, but I could not figure this out. Any suggestions?

 

[Andrew]

Did you ever figure out how to programatically add columsn. I have tried also, but can't figure it out. Thanks.