Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
VB Script Selection API for PD v16
162 views
Skip to first unread message
AK
Mar 12, 2012, 5:16:53 PM3/12/12
to
Hello
I have couple of questions regarding VB Script API for PowerDesigner.
1) I developed VB Scripts to add additional columns to my PDM tables. Currently I hard coded the table name in the script so whenever I need to execute this script for a new table, I have to modify the script to add the new table name and then execute the script. I am wondering if there is an API which can capture the user's selection criteria in PD and populate this value to table name variable in the VB script so that I can then use this script on the fly for any table by selecting a table in the diagram. Do you know what is the API / method which captures the user's selection criteria?
2) Is there a published VB script API for PD v16?
Any help would be greatly appreciated.
Thanks.
I have couple of questions regarding VB Script API for PowerDesigner.
1) I developed VB Scripts to add additional columns to my PDM tables. Currently I hard coded the table name in the script so whenever I need to execute this script for a new table, I have to modify the script to add the new table name and then execute the script. I am wondering if there is an API which can capture the user's selection criteria in PD and populate this value to table name variable in the VB script so that I can then use this script on the fly for any table by selecting a table in the diagram. Do you know what is the API / method which captures the user's selection criteria?
2) Is there a published VB script API for PD v16?
Any help would be greatly appreciated.
Thanks.
wvbigfoot
Mar 13, 2012, 2:51:56 PM3/13/12
to
#1 If you have an extension file,
add table as a metaclass (right click Profile, select new metaclass, checkmark table)
Create a new Method under table (right click table, select new method)
Copy your script into the method. (changes may be needed)
change the name of your method.
create a new menu under table (right click table, select new menu)
Add the method to the menu
save the extension file by clicking Apply or Save
USE: Right click the table, Click your method name from the list of actions.
NOTE The object selected will be passed into the method as: obj
To Create an extension file, Menu --> Model --> Extensions
Click in an empty row, click on properties (leftmost icon)
#2 Metamodel Objects Help
add table as a metaclass (right click Profile, select new metaclass, checkmark table)
Create a new Method under table (right click table, select new method)
Copy your script into the method. (changes may be needed)
change the name of your method.
create a new menu under table (right click table, select new menu)
Add the method to the menu
save the extension file by clicking Apply or Save
USE: Right click the table, Click your method name from the list of actions.
NOTE The object selected will be passed into the method as: obj
To Create an extension file, Menu --> Model --> Extensions
Click in an empty row, click on properties (leftmost icon)
#2 Metamodel Objects Help
AK
Mar 14, 2012, 7:26:40 PM3/14/12
to
Thanks for your help. I was able to modify my VB scripts and add them to Table methods.
In a Physical Data Model, for a given table if we navigate to a Table Properties - Columns tab, for each column that is defined we see M, F, P properties. I would like to add another property called A (Audit Column) so that for each column I am adding to the table I can check this property. How do I accomplish this?
I tried customizing the Physical Data Model extension file and didn't find a way to customize the default form layout.
AK
In a Physical Data Model, for a given table if we navigate to a Table Properties - Columns tab, for each column that is defined we see M, F, P properties. I would like to add another property called A (Audit Column) so that for each column I am adding to the table I can check this property. How do I accomplish this?
I tried customizing the Physical Data Model extension file and didn't find a way to customize the default form layout.
AK
wvbigfoot
Mar 15, 2012, 1:07:35 PM3/15/12
to
On the columns tab, click the icon that looks like a funnel and pencil (4th from the right end), you wil be able to select and set the order of the properties you wish to see.
in...@casimir.ca
Apr 11, 2012, 2:02:52 PM4/11/12
to
On 15 mar, 13:07, wvbigfoot <wvbigf...@yahoo.com> wrote:
> On the columns tab, click the icon that looks like a funnel and pencil (4th from the right end), you wil be able to select and set the order of the properties you wish to see.
>
>
>
> On Wednesday, March 14,20127:26:40 PM UTC-4, AK wrote:
> > Thanks for your help. I was able to modify my VB scripts and add them to Table methods.
>
> > In a Physical Data Model, for a given table if we navigate to a Table Properties - Columns tab, for each column that is defined we see M, F, P properties. I would like to add another property called A (Audit Column) so that for each column I am adding to the table I can check this property. How do I accomplish this?
>
> > I tried customizing the Physical Data Model extension file and didn't find a way to customize the default form layout.
>
> > AK
> On the columns tab, click the icon that looks like a funnel and pencil (4th from the right end), you wil be able to select and set the order of the properties you wish to see.
>
>
>
> On Wednesday, March 14,20127:26:40 PM UTC-4, AK wrote:
> > Thanks for your help. I was able to modify my VB scripts and add them to Table methods.
>
> > In a Physical Data Model, for a given table if we navigate to a Table Properties - Columns tab, for each column that is defined we see M, F, P properties. I would like to add another property called A (Audit Column) so that for each column I am adding to the table I can check this property. How do I accomplish this?
>
> > I tried customizing the Physical Data Model extension file and didn't find a way to customize the default form layout.
>
> > AK
> > On Tuesday, March 13,20121:51:56 PM UTC-5, wvbigfoot wrote:
> > > #1 If you have an extension file,
> > > add table as a metaclass (right click Profile, select new metaclass, checkmark table)
> > > Create a new Method under table (right click table, select new method)
> > > Copy your script into the method. (changes may be needed)
> > > change the name of your method.
>
> > > create a new menu under table (right click table, select new menu)
> > > Add the method to the menu
>
> > > save the extension file by clicking Apply or Save
>
> > > USE: Right click the table, Click your method name from the list of actions.
> > > NOTE The object selected will be passed into the method as: obj
>
> > > To Create an extension file, Menu --> Model --> Extensions
> > > Click in an empty row, click on properties (leftmost icon)
>
> > > #2 Metamodel Objects Help
>
> > > #1 If you have an extension file,
> > > add table as a metaclass (right click Profile, select new metaclass, checkmark table)
> > > Create a new Method under table (right click table, select new method)
> > > Copy your script into the method. (changes may be needed)
> > > change the name of your method.
>
> > > create a new menu under table (right click table, select new menu)
> > > Add the method to the menu
>
> > > save the extension file by clicking Apply or Save
>
> > > USE: Right click the table, Click your method name from the list of actions.
> > > NOTE The object selected will be passed into the method as: obj
>
> > > To Create an extension file, Menu --> Model --> Extensions
> > > Click in an empty row, click on properties (leftmost icon)
>
> > > #2 Metamodel Objects Help
>
> > > On Monday, March 12,20125:16:53 PM UTC-4, AK wrote:
> > > > Hello
>
> > > > I have couple of questions regarding VB Script API for PowerDesigner.
>
> > > > 1) I developed VB Scripts to add additional columns to my PDM tables. Currently I hard coded the table name in the script so whenever I need to execute this script for a new table, I have to modify the script to add the new table name and then execute the script. I am wondering if there is an API which can capture the user's selection criteria in PD and populate this value to table name variable in the VB script so that I can then use this script on the fly for any table by selecting a table in the diagram. Do you know what is the API / method which captures the user's selection criteria?
>
> > > > 2) Is there a published VB script API for PD v16?
>
> > > > Any help would be greatly appreciated.
>
> > > > Thanks.
>
> > > > Hello
>
> > > > I have couple of questions regarding VB Script API for PowerDesigner.
>
> > > > 1) I developed VB Scripts to add additional columns to my PDM tables. Currently I hard coded the table name in the script so whenever I need to execute this script for a new table, I have to modify the script to add the new table name and then execute the script. I am wondering if there is an API which can capture the user's selection criteria in PD and populate this value to table name variable in the VB script so that I can then use this script on the fly for any table by selecting a table in the diagram. Do you know what is the API / method which captures the user's selection criteria?
>
> > > > 2) Is there a published VB script API for PD v16?
>
> > > > Any help would be greatly appreciated.
>
> > > > Thanks.
>
> > On Tuesday, March 13,20121:51:56 PM UTC-5, wvbigfoot wrote:
> > > #1 If you have an extension file,
> > > add table as a metaclass (right click Profile, select new metaclass, checkmark table)
> > > Create a new Method under table (right click table, select new method)
> > > Copy your script into the method. (changes may be needed)
> > > change the name of your method.
>
> > > create a new menu under table (right click table, select new menu)
> > > Add the method to the menu
>
> > > save the extension file by clicking Apply or Save
>
> > > USE: Right click the table, Click your method name from the list of actions.
> > > NOTE The object selected will be passed into the method as: obj
>
> > > To Create an extension file, Menu --> Model --> Extensions
> > > Click in an empty row, click on properties (leftmost icon)
>
> > > #2 Metamodel Objects Help
>
> > > #1 If you have an extension file,
> > > add table as a metaclass (right click Profile, select new metaclass, checkmark table)
> > > Create a new Method under table (right click table, select new method)
> > > Copy your script into the method. (changes may be needed)
> > > change the name of your method.
>
> > > create a new menu under table (right click table, select new menu)
> > > Add the method to the menu
>
> > > save the extension file by clicking Apply or Save
>
> > > USE: Right click the table, Click your method name from the list of actions.
> > > NOTE The object selected will be passed into the method as: obj
>
> > > To Create an extension file, Menu --> Model --> Extensions
> > > Click in an empty row, click on properties (leftmost icon)
>
> > > #2 Metamodel Objects Help
>
> > > On Monday, March 12,20125:16:53 PM UTC-4, AK wrote:
> > > > Hello
>
> > > > I have couple of questions regarding VB Script API for PowerDesigner.
>
> > > > 1) I developed VB Scripts to add additional columns to my PDM tables. Currently I hard coded the table name in the script so whenever I need to execute this script for a new table, I have to modify the script to add the new table name and then execute the script. I am wondering if there is an API which can capture the user's selection criteria in PD and populate this value to table name variable in the VB script so that I can then use this script on the fly for any table by selecting a table in the diagram. Do you know what is the API / method which captures the user's selection criteria?
>
> > > > 2) Is there a published VB script API for PD v16?
>
> > > > Any help would be greatly appreciated.
>
> > > > Thanks.- Masquer le texte des messages précédents -
> > > > Hello
>
> > > > I have couple of questions regarding VB Script API for PowerDesigner.
>
> > > > 1) I developed VB Scripts to add additional columns to my PDM tables. Currently I hard coded the table name in the script so whenever I need to execute this script for a new table, I have to modify the script to add the new table name and then execute the script. I am wondering if there is an API which can capture the user's selection criteria in PD and populate this value to table name variable in the VB script so that I can then use this script on the fly for any table by selecting a table in the diagram. Do you know what is the API / method which captures the user's selection criteria?
>
> > > > 2) Is there a published VB script API for PD v16?
>
> > > > Any help would be greatly appreciated.
>
>
> - Afficher le texte des messages précédents -
Do you can post-it (attach) your VB script ? I would like used-it
thank you
0 new messages