foreign key generator - restrict data

The simplest way to populate your database with test data.

foreign key generator - restrict data

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

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


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

Posts: 69
Joined: Fri Dec 14, 2007 10:15 am

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


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

Kind regards
Posts: 12
Joined: Thu Apr 17, 2008 11:55 am

Postby benhall » Tue Apr 22, 2008 3: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.


Posts: 69
Joined: Fri Dec 14, 2007 10:15 am

Return to SQL Data Generator Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests