Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

How do views work

Former Member

‎2007 Mar 30 5:39 PM

0 Likes
262

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

1 REPLY 1
Read only

RaymondGiuseppi
Active Contributor

‎2007 Mar 30 6:12 PM

0 Likes
237

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