foreign key generator - restrict data

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

foreign key generator - restrict data

Postby rjschave » Fri Apr 18, 2008 7:00 pm

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.
rjschave
 
Posts: 7
Joined: Tue Apr 15, 2008 6:52 am

Postby benhall » Sat Apr 19, 2008 11:33 am

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
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am

Postby Aline » Tue Apr 22, 2008 6:46 am

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
Aline
 
Posts: 12
Joined: Thu Apr 17, 2008 12:55 pm

Postby benhall » Tue Apr 22, 2008 4:05 pm

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
benhall
 
Posts: 69
Joined: Fri Dec 14, 2007 11:15 am


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 1 guest