IFSM247P - Introduction to PowerBuilder

Quiz #5

Section I - True or False. Please write the whole word, not just T or F.

1. ________ A datawindow can attach to multiple transaction objects.

2. ________ The parameters necessary to create the transaction object are completed in the database profile painter.

3. ________ A datawindow is limited to displaying data from one table at a time.

4. ________ A datawindow is limited to saving data to one table at a time.

5. ________ In the statement dw_1.Retrieve(), dw_1 refers to a datawindow object.

6. ________ A datawindow object has events that can trigger PowerScript code.

7. ________ PowerScript is attached to a datawindow object within the Datawindow Painter.

8. ________ Opening a previously saved application object automatically establishes the database connection.

9. ________ The function InsertRow(0) would insert a new row directly above the current row of the datawinow.

10. ________ The function DeleteRow( ) removes the row from both the datawinow control and the database.

11. ________ If AutoCommit = FALSE then updates then the commit statement isn't necessary.

12. ________ The AcceptText() function is used to commit changes to a database.

13. ________ A drop down data window is actually a datawindow inside a datawindow.

14. ________ A drop down datawindow can display one value to the user and store another value in the database

15. ________ By default, the retrieve() function retrieves all rows from the associated table.

Section III - Put the following code statements in the order in which they would happen for the successful retrieval, insertion, and updating of data using a data window. (The first statement that would have to execute would be numbered with a "1", the second a "2", etc…)

16. ________ dw_donor.SetTransObject(sqlca)

17. ________ CONNECT USING sqlca;

18. ________ dw_donor.SetItem(3, 'donor_id)

19. ________ dw_donor.AcceptText()

20. ________ COMMIT USING sqlca;

21. ________ dw_donor.InsertRow(3)

22. ________ DISCONNECT USING sqlca;

23. ________ sqlca.DBMS = 'ODBC'

24. ________ dw_donor.Update()

25. ________ dw_donor.retrieve()