PowerDesigner中NAME和COMMENT的互相转换
来源:互联网 发布:asp无组件上传源码 编辑:程序博客网 时间:2024/05/18 23:28
直接上脚本 可以把脚本保存方便以后用
name2comment.vbs
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 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 if trim(tab.comment)="" then' tab.comment = tab.name end if Dim col ' running column for each col in tab.columns if trim(col.comment)="" then ' col.comment= col.name end if next end if next Dim view 'running view for each view in folder.Views if not view.isShortcut and trim(view.comment)="" 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
comment2name.vbs
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 Private 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 next Dim 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
运行脚本
填入脚本 然后 Run 就可以了。
0 0
- 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和COMMENT的互相转换,需要执行语句
- PowerDesigner中NAME和COMMENT的互相转换,需要执行语句
- powerdesigner中name和comment转换
- PowerDesigner中name与comment互相转换脚本
- 使用PowerDesigner对NAME和COMMENT互相转换
- PowerDesigner Name和Comment 互相转化问题
- PowerDesigner--comment和name互相复制
- powerdesigner中name自动转换到comment和comment2name的vbs脚本
- TCP详解
- 正则表达式
- redux服务端渲染流程
- Android中的主题
- memmove和memcpy函数
- PowerDesigner中NAME和COMMENT的互相转换
- 高并发下数据库优化
- 用CMake构建Qt5项目
- Codeforces Gym 100623B Problem B. Billboard
- volatile
- [LeetCode] 290. Word Pattern
- mtk preloader简单分析
- 用更少的代码发起异步 action
- android笔记之安全开发之使用HTTPS