How to use the generated column in SQL Statement Generator

[kiran.karamsetti]

Hi,

I am generating my id column and i want to use this ID column in my SQL STATEMENT generator to populate another column within the sam e table.

Can any one give suggestions on this. its very urgent.

[Linda Hawksworth]

I have picked up your support request. Would you be able to send me your table creation SQL so that I can do some testing to see whether SQL Data Generator can do what you want. Please indicate which column you wish to populate with the SQL statement generator.

[kiran.karamsetti]

Hi,
I have 2 tables. like:

CCBudget:

CCB_ID FixedRate DefaultRate


And another table(destination):

Scheduling:

SC_ID CCB_ID DefaultRate



I need to fill this Scheduling table. So I made a relationship between the CCBudget and Scheduling on CCD_ID field. So this will get populated from the CCBudget.CCB_ID. So with respect to that Scheduling.CCB_ID i need to populate the DefaultRate from the CCBudget into Scheduling table.

[David Lovemore]

The brute force way of doing this is to populate DefaultRate with junk, and then fix it later with a post-generation script.

You can attach scripts under Edit Projects... Dialog, Scripts Tab.
_________________
David Lovemore
Red Gate Software