Answer / kiran

Dynamic view that can be used like a view in pages and
PeopleCode, but is not actually stored as a SQL view in the
database. Instead, the system uses the view text as a base
for the SQL Select that is performed at runtime. Dynamic
views can provide superior performance in some situations,
such as search records and in PeopleCode Selects, because
they are optimized more efficiently than normal SQL views.

Answer / krishna

Dynamic View is similar to SQL View but we can not build
the dynamic view. When we dont want store the data base
then us dynamic view.

Answer / 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.

What is the use of set control field in record field properties?

0 Answers  

---

Tell me the use of set control field in record field properties?

0 Answers  

---

Is there any way by which you can find out whether the user is in add mode or update mode?

0 Answers  

---

What is the difference between key and alternate search key?

0 Answers  

---

What will be the output of an application engine to use component variables instead of state record?

0 Answers  

---

How should Web Application Servers be usedwith PeopleTools 8.1x and PeopleTools 8.4?

0 Answers  

---

How can you improve the security and usability of a prompt table edit?

0 Answers  

---

What is record group? Which records can be included into a record group?

0 Answers  

---

What is difference between field default and row init?

0 Answers  

---

Tell me the use of temporary records and state record in application engine?

0 Answers  

---

Tell me how to migrate roles from one database to another database?

0 Answers  

---

How can a component have more than one search record? Give a situation.

0 Answers  

---