Comments
Sort by recent activity
Brian Donahue wrote:
Still not sure how to solve this, based on limited information.
Well what information would you like?
I've written the relationship, I could also update the actual create scripts from these tables if that helps? I don't think it'll be fixable in the current version of SQL Data Generator, if anything it might be something that get's added in a future version of SQL Data Generator as I simply don't think that the current generator is able to do this specific job.
If the create script or anything else would help, just ask for specific information and I'll see what I can do. / comments
Brian Donahue wrote:
Still not sure how to solve this, based on limited information.
Well what information would you like?
I've written the relationship, I could also update the actual create ...
Hi,
I'm not sure what this Ruby Extension is but i'll look into it. But no, I do not need to create data as it was a computed column.
Basically I've got a table called Addres filled with the following values;
ID IsPostalBox ZIPCode
1 1 123456
2 1 234567
3 0 123456
4 0 234567
I'd like the following tables called PostBoxOfficeAddres & GeographicalAddress to be filled with the values in the Address table which mean that in the PostBoxOffice Address i'd expect;
ID IsPostalBox PostBoxNumber
1 1 5000
2 1 5001
And geographical;
ID IsPostalBox HouseNumber
3 0 5
4 0 6
I've left some columns out of this picture but I hope it explains what I'm trying to generate.
In the two later table (Postbox & Geographical) the IsPostBox is a computed column, it doesn't actually compute anything, it's a fixed value of 0 or 1. It allows for a FK relationship between the two "sub tables" and the "base table" and it ensures value 1 1 123456 can never be referenced in the Geographical Table.
Also, since it's the FK i cannot change the generator, as it's fixed to "Foreign Key Generator" which posses a problem aswell. / comments
Hi,
I'm not sure what this Ruby Extension is but i'll look into it. But no, I do not need to create data as it was a computed column.
Basically I've got a table called Addres filled with the follow...