How do views work

Former Member — Fri, 30 Mar 2007 16:39:26 GMT

I created a view using 4 tables. If one of the tables doesn't contain data will the view be blank?

Re: How do views work

RaymondGiuseppi — Fri, 30 Mar 2007 17:12:52 GMT

If it is a database table, with inner join, you wont read any record if one of the table is empty.

The other type of view use outer join, so you will get records filled with null values.

<i>Four different view types are supported. These differ in the way in which the view is implemented and in the methods permitted for accessing the view data.

Database views are implemented with an equivalent view on the database.

Projection views are used to hide fields of a table (only projection).

Help views can be used as selection method in search helps.

Maintenance views permit you to maintain the data distributed on several tables for one application object at one time.

Database views implement an inner join. The other view types implement an outer join (see Inner and Outer Join).</i>

Regards

topic Re: How do views work in Application Development and Automation Discussions

How do views work

Re: How do views work