将列的Name换为Comment
来源:互联网 发布:中国创新能力知乎 编辑:程序博客网 时间:2024/06/10 07:42
在生成的PDM中, Powerdesigner界面-tools-Execute Cmmands-Edit/Run Scripts 运行下列代码
Option Explicit
ValidationMode = True
InteractiveMode = im_Batch
Dim mdl 'the current model
'get the current active model
Set mdl = ActiveModel
If (mdl Is Nothing) Then
MsgBox "There is no current Model"
ElseIf Not mdl.IsKindOf(PdPDM.cls_Model) Then
MsgBox "The current model is not an Physical Data model."
Else
ProcessFolder mdl
End If
'This routine copy name into code for each table, each column and each view
'of the current folder
Private sub ProcessFolder(folder)
Dim Tab 'running table
for each Tab in folder.tables
if not tab.isShortcut then
if len(tab.comment) <> 0 then
tab.name = tab.comment
end if
On Error Resume Next
Dim col 'running column
for each col in tab.columns
if len(col.comment) <>0 then
col.name =col.comment
end if
On Error Resume Next
next
end if
next
end sub
Option Explicit
ValidationMode = True
InteractiveMode = im_Batch
Dim mdl 'the current model
'get the current active model
Set mdl = ActiveModel
If (mdl Is Nothing) Then
MsgBox "There is no current Model"
ElseIf Not mdl.IsKindOf(PdPDM.cls_Model) Then
MsgBox "The current model is not an Physical Data model."
Else
ProcessFolder mdl
End If
'This routine copy name into code for each table, each column and each view
'of the current folder
Private sub ProcessFolder(folder)
Dim Tab 'running table
for each Tab in folder.tables
if not tab.isShortcut then
if len(tab.comment) <> 0 then
tab.name = tab.comment
end if
On Error Resume Next
Dim col 'running column
for each col in tab.columns
if len(col.comment) <>0 then
col.name =col.comment
end if
On Error Resume Next
next
end if
next
end sub
- 将列的Name换为Comment
- 将PowerDesigner中列的name生成到注释comment中去.vbs
- PowerDesigner Comment与name的相互装换
- PowerDesigner 赋值comment为name
- 将name的值快速复制到comment中
- PowerDesigner16.5导出SQL语句时如何将name列复制到comment注释里面
- PowerDesigner 12.5 开启注释列 将Comment(注释)及Name(名称)内容互相COPY的VBS代码 根据名称生成注释(完整示例)
- powerdisinger 将name复制到comment
- PowerDesigner 将Comment与Name内容互换
- pd转换name为comment脚本
- PowerDesigner里面将表中name列值复制到comment列
- PowerDesigner中逆向工程将数据库中comment脚本赋值到PDM的name
- PowerDesigner 将表的字段name属性设置到comment注释
- PowerDesigner 将Name中的字符COPY至为空的Comment中
- PowerDesigner 的mysql PDM 的COMMENT注释改为name+comment
- PowerDesigner表的name和comment互转
- powerdesign中表的name和comment互换
- powerdeisger name comment互转的代码
- java常用日期处理
- (Relax 后缀数组1.3)POJ 3415 Common Substrings(求串A和串B中长度不小于k的公共子串数)
- JAVA连库之java-Access
- Win7 Ubuntu下卸载ubuntu
- flume ng编译问题解决
- 将列的Name换为Comment
- android所有权限
- java中this,super关键字的点点滴滴
- java在cmd模式下常用的几条命令
- 记2013移动开发者大会之行
- android电话拨号器
- file's owner以及outlet与连线的理解
- Java多线程面试问题集锦
- Extjs4中的Form之TextArea