what isthe difference between SQL View and Query View?
Answers were Sorted based on User's Feedback
Answer / krishna
In Sql view manually write the SQL statement, Query view
use the PS QUERY tool.
Is This Answer Correct ? | 30 Yes | 7 No |
Answer / reddy
sql view and query view both are database objects,
sql view manually write the query, developer should know the
syntax. query view developed with ps query tool. just drag
drop the fields. no need to learn more about this tool
Is This Answer Correct ? | 20 Yes | 3 No |
Answer / bharath
SQL View: We can manually write the SQL Statements
Query View: This is selected to define the record
definition as a view that is constructed using the
PeopleSoft Query tool.Before u can create the
view ,PeopleSoft Application Designer prompts you to save
the definition.
Is This Answer Correct ? | 10 Yes | 6 No |
Answer / nagaraju
sql view and query both are database objects
sql view manually write the query and query view use the
psquery tool,and both are get the data from database
Is This Answer Correct ? | 3 Yes | 1 No |
Tell me how many sub pages, secondary pages can be created in one level?
Tell me how to migrate roles from one database to another database?
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 section?
Order of Execution of Deferred processing?
1 Answers Kovaion Consulting, NTT Data,
How to populate data into grid in online?
What is page meta data?
Tell me how many sub pages, secondary pages can you create in one level?
What is an array in people code? What is maximum dimension of an array?
What will be the output of an application engine to use component variables instead of state record?
Explain what is project meta data?
What is peoplecode meta data?