PowerDesigner中Comment的值赋给Name

'------------------------------------------------------------
'
'脚本功能:
'    PowerDesigner中逆向工程完成后, 批量将数据库中
'    Comment脚本赋值到PDM的Name
'执行方法:
'    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 
            if len(tab.comment) <> 0 then 
                tab.name = tab.comment
            end if
            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 
    Dim view 'running view   
        for each view in folder.Views   
            if not view.isShortcut then  
                if len(view.name) <>0 then 
                    view.comment = view.name
                end if
                On Error Resume Next 
        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  
'---------------------------END------------------------------
             
  • 0
    点赞
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值