Answer Posted / venkat
BY USING DYNAMIC VIEW WE CAN CHANGE OUR SQL QUERY
DYNAMICALLY AT RUNTIME BY USING SQLTEXT PROPERTY.SO WE CAN
GET DYNAMIC RESULTS ACCORDING TO OUR REQUIREMENT.
BUT IN SQL VIEW WE CAN NOT CHANGE THE SQL QUERY ONCE SAVED.
SO WE CAN GET STATIC RESULTS WHEN USING SQL VIEWS.
Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
What is application package?
Can a PeopleTools 8.4 and a PeopleTools 8.1x application server run on the same machine?
Tell me the use of set control field in record field properties?
Is WebSphere certified on PeopleTools 8.1x?
How to give access to the records that are to be used in a query?
For the servlet layer on the web server, what version of the Java Servlet API are the PIA Java Servlets coded to with PeopleTools 8.4?
Where do you write the peoplecode?
What is differed processing and its advantages?
In which events error & warning are used most extensively?
How the output of a sql query be stored in a variable using peoplecode?
What is html & image meta data?
What is application engine meta data?
What is the purpose of the sqlexec function? What are its benefits and draw backs?
What is page meta data?
Write the syntax to access third level record field using object oriented peoplecode?