PowerDesigner中Name的值赋给Comment
来源:互联网 发布:修改博客数据库 编辑:程序博客网 时间:2024/05/16 08:03
'------------------------------------------------------------
'
'脚本功能:
' PowerDesigner中批量根据对象的name生成comment的脚本
'执行方法:
' Open PDM--Tools--Execute Commands--Run Script
'
'------------------------------------------------------------
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 folde
'------------------------------------------------------------
Private sub ProcessFolder(folder)
Dim Tab 'running table
for each Tab in folder.tables
if not tab.isShortcut then
tab.comment = tab.name
Dim col 'running column
for each col in tab.columns
if InStrRev(col.comment,col.name)<=0 then
col.comment= col.name+"#"+col.comment
end if
next
end if
next
Dim view 'running view
for each view in folder.Views
if not view.isShortcut then
view.comment = view.name
end if
next
'go into the sub-packages
Dim f 'running folder
For Each f In folder.Packages
if not f.IsShortcut then
ProcessFolder f
end if
Next
end sub
'------------------------------------------------------------
0 0
- PowerDesigner中Name的值赋给Comment
- PowerDesigner 将code值赋给name列
- PowerDesigner中NAME和COMMENT的互相转换
- PowerDesigner中NAME和COMMENT的互相转换
- PowerDesigner中name和comment互換
- PowerDesigner中name和comment互換
- PowerDesigner中name和comment互換
- PowerDesigner中name和comment互換
- PowerDesigner中name和comment互換
- PowerDesigner中name和comment互换
- PowerDesigner中name和comment互换
- powerdesigner中name和comment转换
- PowerDesigner中显示name, code,comment的解决方法 修正脚本,执行不会重复添加comment
- PowerDesigner表的name和comment互转
- PowerDesigner 的mysql PDM 的COMMENT注释改为name+comment
- PowerDesigner中逆向工程将数据库中comment脚本赋值到PDM的name
- 将PowerDesigner中列的name生成到注释comment中去.vbs
- PowerDesigner 把Comment写到name中 和把name写到Comment中
- 斐波那契数列
- Activity的生命周期
- 解决iOS程序UI主线程和定时器相互阻塞的问题
- 【ROLLUP】Oracle分组函数之ROLLUP魅力
- javascript对象定义
- PowerDesigner中Name的值赋给Comment
- const的记忆和使用方法
- HTML5 高级编程之像素处理及粒子效果
- ASP.NET Parser Error Message: Could not load type 'Web.Global'.
- java 三个线程分别打印A B C 50次
- sqlite命令使用
- Android输入法扩展之远程输入法
- 乾健也章
- Python初学者(零基础学习Python、Python入门)书籍、视频、资料、社区推荐