首页 > 其他 > 详细

PD中将Comment 从Name复制值

时间:2015-10-13 06:57:28      阅读:232      评论:0      收藏:0      [点我收藏+]

PD中将Comment 从Name复制值,

将以下语句考到,pd 工具栏下的执行脚本中执行下就OK了

技术分享

 

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 
tab.comment = tab.name 
Dim col ‘ running column 
for each col in tab.columns 
if (len(col.comment)<=0) 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 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

  

PD中将Comment 从Name复制值

原文:http://www.cnblogs.com/itclw/p/4873380.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!