B
baruchl
Hello.
I'm using Visio 2005 for Enterprise Arhitects edition, and it seems
like the DB model doesn't support computed columns. I tried to create
such columns in the DB and then reverse engineer it to the Visio, but
Visio "cleverly" removes the computed column code and leave it as a
regualr code.
for example, in the DB I wrote:
create table SNG_TTR_RESULT (
RUN_ID uniqueidentifier not null,
ANALYSIS_TYPE AS CAST('TTR' AS VARCHAR(50)) PERSISTED NOT NULL)
go
and after reverse engineering in Visio and code creation, I get this:
create table SNG_TTR_RESULT (
RUN_ID uniqueidentifier not null,
ANALYSIS_TYPE VARCHAR(50) NOT NULL)
go
Do you know how can I create a computed column in Visio? Failing to do
so will break synchronization between Visio and the DB which will force
me to stop using Visio
...
Thanks,
Busi
I'm using Visio 2005 for Enterprise Arhitects edition, and it seems
like the DB model doesn't support computed columns. I tried to create
such columns in the DB and then reverse engineer it to the Visio, but
Visio "cleverly" removes the computed column code and leave it as a
regualr code.
for example, in the DB I wrote:
create table SNG_TTR_RESULT (
RUN_ID uniqueidentifier not null,
ANALYSIS_TYPE AS CAST('TTR' AS VARCHAR(50)) PERSISTED NOT NULL)
go
and after reverse engineering in Visio and code creation, I get this:
create table SNG_TTR_RESULT (
RUN_ID uniqueidentifier not null,
ANALYSIS_TYPE VARCHAR(50) NOT NULL)
go
Do you know how can I create a computed column in Visio? Failing to do
so will break synchronization between Visio and the DB which will force
me to stop using Visio
...Thanks,
Busi