You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

difference between sql view and Dynamic view

5 replies [Last post]
Guest's picture
Guest

can any one tell what is difference between sql view and dynamic view briefly with examples.

Thanks in advance

CompShack's picture
User offline. Last seen 6 years 9 weeks ago. Offline
Joined: 12/09/2007
Posts: 167
Re: difference between sql view and Dynamic view

Hi there,
The difference is explained very well in PeopleBooks and here it is:

SQL View: This is just your regular database view. It is not an actual physical table on the database but rather a combination of fields taken from one or more records. Its purpose is to offer a way to view information stored on tables.

Dynamic View (form peoplebooks): Defines the record definition that can be used like a view in pages and PeopleCode, but is actually not stored as a SQL View in the database. Instead, the system uses the view text as a base for the SQL SELECT that is executed 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.

Here is a Dynamic view discussion on the forum and a dynamic view related post on the blog.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

Deepak Sharma's picture
Deepak Sharma (not verified)
Re: difference between sql view and Dynamic view

Dyanmic view is similar to SQL view but we can't build the dynamic view.
SQL view also refers to a database object but SQL view doesn't refers it.

Guest's picture
Guest (not verified)
Re: difference between sql view and Dynamic view

we need more clarifications on dynamic view

Hari_aindian's picture
User offline. Last seen 6 years 40 weeks ago. Offline
Joined: 08/02/2010
Posts: 84
Re: difference between sql view and Dynamic view

Let me try to explain.

Let say you are having a field called "Department id"(DEPTID)in a page and another field called "Dept Contact Person" prompt is there in the same page. Now the scenario goes like this

We need to show the EMPLID of Dept contact person based on the selected DEPTID. In the begining we never know which deptid is going to be selected by the user.. So at run time user selects the DEPTID then based on this selected DEPTID we need to populate the Dept contact person prompt.

For this purpose we are going for dynamic view. At run time selected DEPTID will be passed to the SQL which fetches the related Contact person emplid.

Do let me know your concern about this.

Regards,
Hari.A

Guest's picture
Guest (not verified)
Re: difference between sql view and Dynamic view

Can you point to a drawing that would explain it better for those who are more visual learners?