PS Mixed - How to use a Dynamic prompt table? what we need to do for it? what should be the length of the field

GeekInterview.com > Interview Questions > Peoplesoft > PS Mixed

Go To First | Previous Question | Next Question

PS Mixed | Question 183 of 200

How to use a Dynamic prompt table? what we need to do for it? what should be the length of the field to be added in the DERIVED record?

Total Answers and Comments: 3

Last Update: February 14, 2007 Asked by: Aparna

Sponsored Links

Best Rated Answer

—

Submitted by: Tej

This is the confusion that many people have. The Dynamic Prompt table is used when the prompt values are defined in the run time.Lets say if X = 1 then use 'EMPLOYEES' as the prompt table else use 'JOB' as the prompt table. end-if.Now in the record definition and record field properties you set the prompt table as %fieldnameThis fieldname can be any field name. (This is normally taken from a derived work record). This field should be placed on a page and make it invisble (usually).During the Row init.....you have to set a value to this field. This value will be the prompt record name. as long as this record is a valid one and the field contains a valid record name this dynamic Prompt table is used.Normally we use the field EDITTABLE as the Prompt table container...if the field is RECNAME then you should use %RECNAME instead of %fieldname.

Above answer was rated as good by the following members:
yonderowl

September 19, 2006 07:11:39

Prabhu

RE: How to use a Dynamic prompt table? what we need to...

In order to use a dynamic promt table; the field that is going to have the dynamic promt must point to a field in the DERIVED record. The promt table can be dynamically assigned with the following code.

If(condition)

derivedrecordfield.value promttable1

else

derivedrecordfield.value promttable2

end-if;

Is this answer useful? Yes | No

November 13, 2006 10:23:29

People User

RE: How to use a Dynamic prompt table? what we need to...

edittype

Is this answer useful? Yes | No

February 14, 2007 07:00:18

Tej

RE: How to use a Dynamic prompt table? what we need to...

This is the confusion that many people have. The Dynamic Prompt table is used when the prompt values are defined in the run time.Lets say if X 1 then use 'EMPLOYEES' as the prompt table else use 'JOB' as the prompt table. end-if.Now in the record definition and record field properties you set the prompt table as fieldnameThis fieldname can be any field name. (This is normally taken from a derived work record). This field should be placed on a page and make it invisble (usually).During the Row init.....you have to set a value to this field. This value will be the prompt record name. as long as this record is a valid one and the field contains a valid record name this dynamic Prompt table is used.Normally we use the field EDITTABLE as the Prompt table container...if the field is RECNAME then you should use RECNAME instead of fieldname.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank