sybasepowerdesigner.com

powerdesigning.com

Adding Seed Data to the After Tab | Power Designing

https://powerdesigning.com/2010/04/28/adding-seed-data-to-the-after-tab

A blog on PowerDesigner. Adding Seed Data to the After Tab. Posted by Rich Kier. April 28, 2010. On the PowerDesigner group today. Mark wanted to add seed data to the after script on a table, which is fairly common (we do it all the time); but with a brilliant twist. The goal is to store the seed data script in an external file and have it end up in the DDL when we generate the database. I thought this would be pretty easy by tweaking pieces of code I already, but there were a few gotchas. If you’r...

powerdesigning.com

New Feature Request | Power Designing

https://powerdesigning.com/category/new-feature-request

A blog on PowerDesigner. RSS feed for this section. This category contains 1 post. New Feature Request: Persist Model Checks. Posted by Rich Kier. September 28, 2009. I’ve been a bit distracted from my scripting work, but I thought it might be fun to post some thoughts on new features I’d like to see in the tool. You can’t mark a warning as reviewed. The results of a check model aren’t stored anywhere. If you’re reading this (bored? What new features would you like to see? Arup Nanda's Blog.

powerdesigning.com

Rich Kier | Power Designing

https://powerdesigning.com/author/rkkier

A blog on PowerDesigner. Rich Kier has written 20 posts for Power Designing. Data Modeling Made Simple with PowerDesigner. Posted by Rich Kier. October 21, 2011. If you’re not following George McGeachie at Metadata Junkie. You should be. George has just completed a book with Steve Hoberman. 8220;Data Modeling Made Simple with PowerDesigner. Read more at Metadata Junkie: The book is finished! Events – Before Database Generate (More or less). Posted by Rich Kier. October 9, 2011. To set the properties of a...

powerdesigning.com

Events – Initialize | Power Designing

https://powerdesigning.com/2011/05/26/events-initialize

A blog on PowerDesigner. Events – Initialize. Posted by Rich Kier. May 26, 2011. This will be the first of several posts on events. As many of my friends and colleagues have pointed out, I don’t have a great track record putting out new posts on a regular basis. So, right now, I’m committing to at least one more post on this topic. The Sybase. So, you’ve created or opened an XEM file and added the table metaclass. If you’re not sure how to do this, see several of my prior posts. Step 1: Add an event.

powerdesigning.com

Selection Goodness | Power Designing

https://powerdesigning.com/2009/10/26/selection-goodness

A blog on PowerDesigner. Posted by Rich Kier. October 26, 2009. Today’s post is on selections. Selections are a great way to script changes to multiple objects and a great way to make your custom methods more flexible. Selections are just what they sound like, a group of objects, placed into a collection for processing. Let’s jump right in with a simple example:. Dim mySel Set mySel = ActiveModel.CreateSelection mySel.AddObjects ActiveModel, cls table, false, true. That’s not too bad, but notice our SetN...

powerdesigning.com

Questionable Quotations | Power Designing

https://powerdesigning.com/2010/06/22/97

A blog on PowerDesigner. Posted by Rich Kier. June 22, 2010. A friend just found me quoted on the web, which is surprising considering how little I say is actually useful. I’ve been participating in Steve Hoberman’s design challenges. It’s my blog, so here are links to the articles where I appear. Creating Extended Dependencies in VBScript. Advanced Display Options and an End to Custom Shapes ». Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:.

powerdesigning.com

Advanced Display Options and an End to Custom Shapes | Power Designing

https://powerdesigning.com/2011/01/26/an-end-to-custom-shapes

A blog on PowerDesigner. Advanced Display Options and an End to Custom Shapes. Posted by Rich Kier. January 26, 2011. Okay, so it’s been a LONG time since I’ve posted, but two small kids and a job (okay, mostly the kids) will do that. Anyway …. Well, 15.3 fixes that for us. Let’s look at a quick sample. Here’s the “before” picture with the red and blue colors indicating the subject areas. Now, let’s look at how we can do it better. Make sure they’re both selected and click “OK” again&#4...Now, on any dia...

powerdesigning.com

Transformation – Creating a Reference Table | Power Designing

https://powerdesigning.com/2011/07/27/transformation-creating-a-reference-table

A blog on PowerDesigner. Transformation – Creating a Reference Table. Posted by Rich Kier. July 27, 2011. So, for our example, we’ll create a pre-generation transform that will create a generic lookup table. Our code will be a little different from the event code earlier because we’re working with a CDM instead of a PDM (table becomes entity, etc.). We’re going to key our transform off the column domain. So instead of cluttering up your conceptual data model. Which transformations to allow/deny (show/hid...

powerdesigning.com

Events – Validate Basics | Power Designing

https://powerdesigning.com/2011/06/20/events-validate-basics

A blog on PowerDesigner. Events – Validate Basics. Posted by Rich Kier. June 20, 2011. I’ve decided to split part two into two parts (maybe part 3 will be split in thirds). First, a general discussion of validation events, pros, cons and things you should know. I’ll follow up in another week (or two, or three – my record here isn’t great) with some additional samples of checks and automation done via validation events. I see two potential uses for them (please let me know if you’ve got any others). For d...