Home » Developer & Programmer » Forms » can anybody answer...................
can anybody answer................... [message #83606] Fri, 07 November 2003 00:04 Go to next message
Messages: 15
Registered: April 2003
Junior Member
can anybody answer these few questions

Q1 You need to create a form for payroll applicaition that will allow the user to view all information
for any employee Id queried. THis data should be displayed to the user in agrouped format.the user
should be able to choose which information they want to see from a pull down list containing the values
personal and payroll. Which format should you use to create this form?

A One content canvas and multiple stacked canvases.
B. One content and one stacked canvas.
C. Tab canvas with several tab pages.
D. One content canvas.
E. A horizontal and vertical toolbar.

Q2 At design time,you create a query record group for the lov associated with the hotel text item
in a form module for the travel planner application. when is the record group deleted and when is record group populated?

A when the user navigates to the hotel item.
B when the form module successfully complies.
C after form builder validates the select statement and dismisses the new record group dialog box.
D when the user enters data in the hotel item, and the validate from list property for the hotel item is
set to yes.

Q 3 You need to base a data block on the emp table, but you do not want to give the users of the
application access privileges on the table. Which type of data source wourld you use to create the data block?

A table
B transactional trigger
C stored procedure
D from clause query

i will be very grateful
Re: can anybody answer................... [message #83623 is a reply to message #83606] Mon, 10 November 2003 03:43 Go to previous message
Messages: 129
Registered: September 2002
Senior Member
First answer is D coz u just need one canvas containing the query block and control block above that on the same canvas from where the user will base his query criteria.second is not very clear coz it says when is the record group deleted and when is the record group populated.so this means they r 2 questions . Third is C.Coz u can create stored procedure .Grant access rights on this procedure and base a block on this procedure.SO no need for having access priviliges on the table directly.
Previous Topic: master/detail relation
Next Topic: PLS HELP MAAHER..........
Goto Forum:

Current Time: Sat Aug 13 01:34:56 CDT 2022