Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between Translate & Prompt tables.
What are the occasions when to use Translate values instead
of Prompt table? What is the advantage of one over the other?
- 5 Answers
- 16172 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashish rawat
Translate tables are used as a list box item. You will use
translate table when you have less option to display like
in gender (male/female). But if you have many options like
selecting country in this case you have to use prompt table.
| Is This Answer Correct ? | 18 Yes | 1 No |
Answer / mukundhan
Translate Tables :
Translate values have to be added through the App Designer
Translate tables have a max lenght of 4 char for each
element.
There can be only 30 entries in a translate table.
These values are stored on a people tools table called
XLATTABLE.
Prompt Table :
Prompt table values may be modified when users add data to
the system.
Prompt table elements have no such limitation.
Prompt table can have any number of entries.
Is used to provide users with validate values from other
tables. Prompt table with edit prompt table with no edit.
| Is This Answer Correct ? | 8 Yes | 0 No |
The Translate table option houses strings of length < 5.
The translate table values are readily available reducing
the trip to db everytime .
The transalte table values are faster in performance.
The translate table option is used when # of options is less
The Prompt Table values houses strings of any lenght < 255.
The prompt table values can also bring other related
information to the page.
The prompt table values are fetched by making a trip to DB
everytime.
The prompt table values are useful for multi-lingual setup.
| Is This Answer Correct ? | 5 Yes | 1 No |
The Translate table option houses strings of length < 5.
The translate table values are readily available reducing
the trip to db everytime .
The transalte table values are faster in performance.
The translate table option is used when # of options is less
The Prompt Table values houses strings of any lenght < 255.
The prompt table values can also bring other related
information to the page.
The prompt table values are fetched by making a trip to DB
everytime.
The prompt table values are useful for multi-lingual setup.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / swapnil
Another difference to be noted is that the Translate Values
are loaded into buffer each time the dropdown is clicked(in
other words each time they are initiated).
Prompt Values are not loaded into buffer directly, instead
in inbuilt query fires which populates data from the DB
tables.
| Is This Answer Correct ? | 2 Yes | 0 No |
Explain the difference between Translate & Prompt tables. What are the occasions when to use Translate values instead of Prompt table? What is the advantage of one over the other?
What is getlevel0()? What is the use of %subrec and %selectall functions?
Which peopletool is used to input peoplecode?
A user reports that when a page loads, the Advanced search page is getting loaded instead of normal search page. Why ?
What environments supported by people tools tool set?
How the output of a sql query be stored in a variable using peoplecode?
Is there any way by which you can find out whether the user is in add mode or update mode?
Explain what is menu meta data?
What is component meta data?
You want to connect report through process scheduler. How would you do that?
What are the built-functions used to control translate values dynamically?
How to migrate roles from one database to another database?
PeopleSoft HRMS 
