topic Re: Database view updation? in Application Development and Automation Discussions

Database view updation?

Former Member — Fri, 19 Oct 2007 06:07:53 GMT

Hi guys,

Can any one tell me how the database view is updated automatically when we add a field in the tables used by database view.

Thanks,

GURU

Re: Database view updation?

Former Member — Fri, 19 Oct 2007 06:12:30 GMT

Database views are created by joining the application related transparent btables

when those transaparent tables are updated then accordingly the Views are get updated as per the joins defined between the tables

Database views are implement an inner join, that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. Inconsistencies between primary and secondary table could, therefore, lead to a reduced selection set.

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

Regards

Anji

Re: Database view updation?

hymavathi_oruganti — Fri, 19 Oct 2007 06:17:49 GMT

Hi, using database view, we can update only a single table.

using database view we can update only single table. but we can join multiple tables and read data from multiple tables.

To update multiple tables, we go for maintanace views.

any view is created by joining the database table fields.

so, when the value in the field is updated, obviously the view should have the latest values as the view uses those fields.otherwise synchronization will not be there.

Re: Database view updation?

Former Member — Fri, 19 Oct 2007 06:28:39 GMT

Hi,

I have added a field in the EQUI table which is used by database view ITOB.

It has been updated in one system but in other system it is still not updated.

Is there any reason why the view is not updated?

Thanks,

GURU

Re: Database view updation?

hymavathi_oruganti — Fri, 19 Oct 2007 06:29:36 GMT

in the other syatem, is the table EQUI UPDATED IN THE OTHER SYSTEM?

Re: Database view updation?

Former Member — Fri, 19 Oct 2007 06:43:53 GMT

Yes the table is updated in other system.