Questions And Answers for PowerBuilder Interviews

Question

Explain the steps that are required to update a multiple-table DataWindow?

Click here to see the answer

Answer

In short, using the Modify function or .Object notation, you need to make one table updatable. You also need to set the primary keys for that table. Then update the DataWindow with FALSE argument for the reset option in the Update() function. After successful update, make the second table updatable and the first one not-updatable. Now call Update() function with TRUE for the reset option (If there are more than two tables, use the TRUE option to the last table to be updated). Commit after successful update and Rollback on unsuccessful update.

Click here to go to top of the page.

Home	Previous Lesson: Question: #25 of #131 Next Lesson: Question: #27 of #131