Allan,

We usually do not run the script from Visio "as is". Usually the script is
broken into separate files, based on what our DBAs want. We also take these
files are put them into a source management system such as Safe Source. Then
we apply the actual changes on a schedule that suits the project.

If you are running in a development environment this still applies - simply
edit the script placing the function earlier in the script. I still
recommend breaking the script into a set of related files and apply then in
the correct order.


Pat


-----Original Message-----
From: allan lindgren [mailto:allan_lindgren@...]
Sent: Tuesday, July 06, 2004 3:01 PM
To: jcm@yahoogroups.com
Subject: [JCM] VISIO DDL and functions

When using Visio for enterprise to generate the ddl from ER diagrams we are
having a problem when a column in a view references a function to be
declared in the model. Since the declare function scripts run after the
physical model generation for a ddl from Visio, this errors out. How can we
avoid this error?

Allan Lindgren
mailto:allan_lindgren@...




~~~~~~ Sponsor's Message ~~~~~~~~~~~~~~~~~~~~~
Would you like to learn more about Object-Role Modeling (ORM)?

Then check out InConcept's ORM Seminars!

These seminars will focus on the use of Object-Role Modeling to correctly
model your business data requirements. Each day also contains "hands on"
labs where students practice the technique while ORM-certified instructors
give one-on-one assistance.

Custom on-site courses are also available.

For more information, please see
http://www.inconcept.com/training/ormseminar.html or e-mail
training@....
Yahoo! Groups Links