Questions And Answers for PowerBuilder Interviews

Question

What is the difference between SetTrans() and SetTransObject()?

Click here to see the answer

Answer

In simple terms, SetTrans() gives you no control on the transactions. It automatically connects to and disconnects from the database after each Retrieve() and Update() function. It is useful when the number of connections are limited, but, you can't use this for multi-table update. On the other hand SetTransObject() gives you full control over the transactions. It is your responsibility to connect to and disconnect from the database and also, you need to issue COMMIT/ROLLBACK statements. This method is more efficient since there is no connect/disconnect overhead for each database operation.

Click here to go to top of the page.

Home	Previous Lesson: Course 5:: Session 1 :: Page 1 Next Lesson: Question: #2 of #131