ColdFusion General :: Record from table to table or DB to DB
This thread was displayed: 1,214 times
Starting with 17th May 2007, Adobe Systems will stop offering support for any version of the discontinued InterAKT products. As a result, we will not answer to new support incidents starting with May 17th, 2007. Pending support incidents will still be followed in order to be closed. The product forums will remain open and be transformed in user-to-user forums. The general forums will be made read-only and not allow new posts or comments.
For more information about the affected products visit: www.interaktonline.com/Support/
John English
12-12-2006 19:56:54 GMT +2
|
How would I create a update record form that reads from one table (or db), allows data to be updated in the form, then submit this to another table (or db)?
|
|
|
Razvan Racasanu[InterAKT]  12-14-2006 14:50:32 GMT +2
|
Hello,
You can do this by creatinga regular insert form on the second table (the one on which you want to insert). Then, create a filtered recordset on the first table that extracts the record that contains the data you want to insert into the second table. Then, edit the insert transaction and set as default value the values from the recordset.
Regards,
Razvan RACASANU
|
|
|
John English
12-15-2006 01:17:17 GMT +2
|
Your suggestion works flawlessly. Thank you!
Is it possible to avoid duplicating an existing record in the table storing the new record? The goal is to use the same form multiple times for the same record because each record may need multiple updates over time.
|
|
|
Razvan Racasanu[InterAKT] 12-15-2006 11:39:03 GMT +2
|
Hello,
If I understand correctly, besides inserting the new record, you also want to update it. In this case, you need to make a new file with an update transaction for that record.
Regards,
Razvan RACASANU
|
|
|
John English
12-15-2006 15:31:08 GMT +2
|
That works! Thank you for your kind and knowledgable advice. Have a restful and healthy holiday season.
|
|
|
