Red Gate forums :: View topic - foreign key generator - restrict data
Return to www.red-gate.com RSS Feed Available

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

foreign key generator - restrict data

Search in SQL Data Generator 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
rjschave



Joined: 15 Apr 2008
Posts: 7

PostPosted: Fri Apr 18, 2008 7:00 pm    Post subject: foreign key generator - restrict data Reply with quote

The foreign key generator does not allow us to filter data selected from the related table.

I may have a field related to a table containing a list of states. When I generate data in the main table I want to be able to restrict which states are selected (i.e. Michigan & Wisconsin).

Currently I have to remove the relationship before I can select the SQL statement generator or RegExp generator.
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Sat Apr 19, 2008 11:33 am    Post subject: Reply with quote

Hello,

Thanks for the suggestion, it is much appreciated. A number of other users have also requested this feature and we are looking at the best way of solving this for future versions.

Once again thank you, if there are any other features would you like to see then please let us know.

Thank you

Ben
Back to top
View user's profile Send private message
Aline



Joined: 17 Apr 2008
Posts: 12

PostPosted: Tue Apr 22, 2008 6:46 am    Post subject: Reply with quote

Hello

I'm also missing this feature.
I think, for the moment I will delete this records with a script after data generation.

Kind regards
Aline
Back to top
View user's profile Send private message
benhall



Joined: 14 Dec 2007
Posts: 98

PostPosted: Tue Apr 22, 2008 4:05 pm    Post subject: Reply with quote

Hi Aline,

In the mean time, that is a great solution to getting around this the problem.

Just so everyone is aware, the post generation script feature can be found on the project configuration dialog on the scripts tab.

Thanks

Ben
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