温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

Powerdesigner数据库反向生成PDM显示中文

发布时间:2020-07-14 11:35:07 来源:网络 阅读:974 作者:zhaowenming21 栏目:数据库

Tools->Execute Commands->Edit/Runscript…

执行以下脚本,在Powerdesigner从数据库反向生成PDM时,NAME显示中文。

 

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 folder

Private sub ProcessFolder(folder)

Dim Tab 'running table

for each Tab in folder.tables

if not tab.isShortcut then

if tab.comment ="" then

else

tab.name=tab.name+"("+tab.comment+")"

on error resume next

end if

Dim col ' running column

for each col in tab.columns

if col.comment="" then

' MsgBox "表"+tab.name+"列"+col.name +"没有comment"

else

col.name=col.name+"("+col.comment+")"

on error resume next

end if

next

end if

next

Dim view 'running view

for each view in folder.Views

if not view.isShortcut then

if view.comment="" then

MsgBox "视图"+view.name  +"没有comment"

else

view.name=view.name+"("+view.comment+")"

on error resume next

end if

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


向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI