powerdeisger name comment互转的代码
来源:互联网 发布:mysql小于等于怎么写 编辑:程序博客网 时间:2024/05/24 02:20
- 代码一:将Name中的字符copy至comment中
Option Explicit
ValidationMode = True
InteractiveMode = im_BatchDim 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 comment 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
tab.comment = tab.name
Dim col ' running column
for each col in tab.columns
col.comment= col.name
next
end if
nextDim 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
--------------------------------------------
另外在使用REVERSE ENGINEER从数据库反向生成PDM的时候,PDM中的表的NAME和CODE事实上都是CODE,为了把NAME替换为数据库中Table或Column的中文Comment,可以使用以下脚本:
- 代码二:将Comment中的字符COPY至Name中
Option Explicit
ValidationMode = True
InteractiveMode = im_BatchDim 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 IfPrivate sub ProcessFolder(folder)
On Error Resume Next
Dim Tab 'running table
for each Tab in folder.tables
if not tab.isShortcut then
tab.name = tab.comment
Dim col ' running column
for each col in tab.columns
if col.comment="" then
else
col.name= col.comment
end if
next
end if
nextDim view 'running view
for each view in folder.Views
if not view.isShortcut then
view.name = view.comment
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
-----------------------------------------------------------------------
以上两段代码都是VB脚本,在PowerDesigner中使用方法为:
PowerDesigner->Tools->Execute Commands->Edit/Run Scripts
将代码Copy进去执行就可以了,是对整个CDM或PDM进行操作
- powerdeisger name comment互转的代码
- pdm Comment转name
- 【转】PowerDesigner 中将Comment(注释)及Name(名称)内容互相COPY的VBS代码
- PowerDesigner 的mysql PDM 的COMMENT注释改为name+comment
- PowerDesigner 中将Comment(注释)及Name(名称)内容互相COPY的VBS代码
- PowerDesigner 中将Comment(注释)及Name(名称)内容互相COPY的VBS代码
- PowerDesigner 中将Comment(注释)及Name(名称)内容互相COPY的VBS代码
- PowerDesigner 中将Comment(注释)及Name(名称)内容互相COPY的VBS代码
- PowerDesigner 中将Comment(注释)及Name(名称)内容互相COPY的VBS代码
- PowerDesigner 中将Comment(注释)及Name(名称)内容互相COPY的VBS代码
- PowerDesigner表的name和comment互转
- 将列的Name换为Comment
- powerdesign中表的name和comment互换
- #pragma comment(lib,"Name.lib")的用法?
- PowerDesigner中批量根据对象的name生成comment的脚本(转)
- PowerDesigner中显示name, code,comment的解决方法 修正脚本,执行不会重复添加comment
- PD设置name与comment的相互复制
- PD设置name与comment的相互复制
- day22:RDD的依赖关系彻底解密
- day21:从Spark架构中透视Job
- 《Linux总线、设备与驱动》USBHID设备驱动
- Android环境搭建(不需要翻墙,直接配置安装开发环境)
- hrbust 1283 又见皇后【dfs】
- powerdeisger name comment互转的代码
- 需求管理之如何撰写优秀的需求
- js遍历数组
- Linux设置网络连接
- Python中str操作的学习
- UI控件常见的属性
- Android Studio中如何重命名文件
- 需求管理之勇于直面需求变更
- 雅虎开源CaffeOnSpark:基于Hadoop/Spark的分布式深度学习