Page 303 - Open Soource Technologies 304.indd

Unit 13: Working With Reports

8. Once you have gone to all the trouble of a database
(a) Developing (b) Managing
(c) Developing and managing (d) None of the above

9. There are two steps to creating a
(a) Data report (b) Data Environment
(c) Data adopter (d) None of these
10. In order to use the database in your report, you need to create query to retrieve the
Information from the application
(a) True (b) False

13.13 Review Questions

1. What is RDO?
2. What are the two main objects that you can place on the surface of a Data Environment?
3. Which ADO object is always associated with a cursor?

4. Describe some of the basic characteristics of Date Environment.
5. What are the primary components of the data environment?
6. Name the four different cursor and locking types in ADO and describe them briefly.

7. Under the ADO Command Object, what collection is responsible for input to stored
procedures?
8. How to create a Data Environment Report Using Grid?

9. How to setup DataSource, DataMember and DataField to display?
10. Which property of a Recordset object should you check to see if the preceding call to the
Find method was successful?
11. How could you prevent one of ADO’s Will event procedures from running multiple times
during an application session?

12. What is the purpose of the ADO Errors collection?
13. You’ve been asked to build a customer phone list report. The phone list will be populated
from a table named CUSTLIST, found in the SALES98 database on a SQL server named
FARGO. In order to keep development time to a minimum, you are asked to use the Data
Environment Designer. This report will be the only purpose of this application. After
selecting a new Data Project template, what steps should you take to build this report?

14. How do you dynamically bind a text box control to an ADO Recordset object?
15. How can you place a DataGrid on a form that is automatically bound to the Recordset
of a Data Environment’s Command object? (Select all that apply.)

LOVELY PROFESSIONAL UNIVERSITY 297