Red Gate forums :: View topic - Another request for setting Column A based on Column B
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Data Generator 2
SQL Data Generator 2 forum

Another request for setting Column A based on Column B

Search in SQL Data Generator 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
DavidGInNewWest



Joined: 12 Sep 2012
Posts: 1
Location: Canada

PostPosted: Thu Sep 13, 2012 5:18 pm    Post subject: Another request for setting Column A based on Column B Reply with quote

I am also in the boat where, in order to be able to generate data, I need to inspect various columns in a row before setting another column.

Our database has a table that stores patient problems. A problem may be based on a predefined problem, or may be ad-hoc. There is a trigger that says, "If the ad-hoc column if set, the pre-defined column cannot be, and vica versa".

I also see that the data generation for an individual column is isolated - the tool generates Column 1, then Column 2, then Column 3 - it's apparent in the interface and capabilities of the software. Data Generator 2 is just not designed to work row-by-row; it works column-by-column.

It would be nice if each column-function (the code that returned a row for the column) operated on a row-by-row basis, rather than in a generate-all-column-data-at-once fashion.

I understand this is not possible unless I go through the trouble of duct-taping IronRuby onto the outside (and then learning Ruby). What about IronPython?

I guess I can sort of work around this by disabling the trigger on the table by adding before-and-after scripts to the project, but that won't work in all cases, and could lead to invalid results when I test.

Finally, the UI is kind of screwed up for Windows 7 - lots of labels are squished together, UI elements overlap, etc.

The tool is great for generating a users table, but it breaks down pretty quickly once the rules get a bit more complicated....
Back to top
View user's profile Send private message
Manfred.Castro



Joined: 23 Apr 2012
Posts: 209

PostPosted: Fri Sep 14, 2012 7:31 pm    Post subject: Reply with quote

I have added your request to the existing request under the interna reference number of SDG-682

As far as the display issue I am running windows 7 and do not experience the issue you are describing. I believe it likely to be a diplay setting on your machine causing the issue either a resolution setting or DPI.
_________________
Manfred Castro
Product Support
Red Gate Software
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group