D
Dave Taylor
I developing an application with the Visio ActiveX control which will be
used to draw process flowsheets. The streams and nodes of these flowsheets
will have associated data in a SQL Server database that is updated daily
(both for historical tracking of the process and for forward prediction).
The flowsheet itself may be altered from time to time to reflect actual
process changes or to investigate proposed changes. My question comes down
to where to store the Visio drawing. I was thinking of creating an XML file
of the drawing and storing it to a text field in the database. Of course,
the other option is to have a directory where the .vsd files are stored and
store only the path name in the database. Any thoughts as to which method
is best? The drawings are not terribly large, maybe 75-100 streams (i.e. 1D
connectors) and 30-40 nodes (2D Shapes).
Thanks
Dave Taylor
used to draw process flowsheets. The streams and nodes of these flowsheets
will have associated data in a SQL Server database that is updated daily
(both for historical tracking of the process and for forward prediction).
The flowsheet itself may be altered from time to time to reflect actual
process changes or to investigate proposed changes. My question comes down
to where to store the Visio drawing. I was thinking of creating an XML file
of the drawing and storing it to a text field in the database. Of course,
the other option is to have a directory where the .vsd files are stored and
store only the path name in the database. Any thoughts as to which method
is best? The drawings are not terribly large, maybe 75-100 streams (i.e. 1D
connectors) and 30-40 nodes (2D Shapes).
Thanks
Dave Taylor