Activity overview
Latest activity by Trish
Seeds don't generate the same data when used with different Repeating Keys
Hello,I'm hoping you can explain to me what I'm doing wrong. This my setup:5000 rows are being generated for Table A1000 rows are being generated for Table B, which has a foreign key to Table A200...
Thanks - that explains it.
In that case, please can I ask you to put in a request to also change the help text for the option above "Repeat key values between n1 and n2 times"? This includes the word 'random' but isn't. SQL Data Generator selects a value from the referenced column(s) at random, and then repeats the value within the specified number of times in adjacent generated rows.
This solved my problem - as I set it to "Repeat key values between 3 and 3 times" then I get every one of my 1000 foreign keys used exactly 3 times. So that's not 'random' - if we were talking about a music playlist it would be "shuffled".
An option similar to the one above but not 'shuffled' but sequential would also be really useful feature.
Thanks,
Trish / comments
Thanks - that explains it.
In that case, please can I ask you to put in a request to also change the help text for the option above "Repeat key values between n1 and n2 times"? This includes the w...
Foreign Key - Repeat key values at random - doesn't use each value once
We've been trying to track down a bug in our code, only to discover that it's because the data I've generated using the SQL Data Generator is invalid. I think the Automatic Foreign Key 'Repeat key...