Stored Procedure

[James]

Hello;

I am a new user to Visio and to SQL Server. I have a lot of experience with
VBA (Excel). I am using the reverse engineer option in Visio to create
diagrams for a database on a SQL server. Is there a way to use VBA to
highlight information from a stored procedure? For example, a procedure to
find if a sale quota has been met, and if it has I would like to have the
correct table show up as green.

 

[Barb Way]

We don't publish an API for the Database modeling solution, so we don't
generally support programming against the DB objects. Also, the modeling
solution is able to read and display information about the Schema and
objects in a database, but it does not 'Run' stored procedures, or have any
access to data stored within the tables.

If you would like to explore using Data from a SQL server in general Visio
diagrams, however, you will want to look at using Visio 2007 to create
connected drawings. Take a look at the Visio 2007 demos on Office Online :
http://office.microsoft.com/en-us/visio/CH100740891033.aspx?pid=CL1007292810
33

In particular, I think you will find this topic interesting :
http://office.microsoft.com/en-us/visio/HA100518191033.aspx

Hope that helps!

Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------
Thread-Topic: Stored Procedure

Hello;

I am a new user to Visio and to SQL Server. I have a lot of experience
with
VBA (Excel). I am using the reverse engineer option in Visio to create
diagrams for a database on a SQL server. Is there a way to use VBA to
highlight information from a stored procedure? For example, a procedure to
find if a sale quota has been met, and if it has I would like to have the
correct table show up as green.