How to use the generated column in SQL Statement Generator

• 
  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.

  Linda Hawksworth January 05, 2009 08:00

  - 0 +
• 
  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.

  kiran.karamsetti January 06, 2009 01:04

  - 0 +
• 
  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 January 07, 2009 05:46

  - 0 +

Add comment

Please sign in to leave a comment.