topic Re: Insert entry to a view in Application Development and Automation Discussions

Insert entry to a view

Former Member — Tue, 29 Sep 2009 09:52:41 GMT

Hi All,

i need to insert an entry to a 'Z' view, which is join of 2 tables (TRUG & TRUGT).

for that, i am inserting the entry to table TRUG and able to insert with the program, but i am not able to insert the Description of the text table TRUGT..so, the result is, am getting the values from TRUG to Z view, but am missing the description value in the Z view which is coming form TRUGT..

could anyone help me in inserting an entry to a view..

Thanks,

Pavan

Re: Insert entry to a view

Former Member — Tue, 29 Sep 2009 10:30:36 GMT

Hello

You do not need insert values with the programm.

For Reason for Variances maintain use maintance view V_TRUG. Create new record, give description and save.

All data will be in TRUG, TRUGT and your Z-view.

Re: Insert entry to a view

Former Member — Tue, 29 Sep 2009 11:44:01 GMT

Hi,

Tnx for the quick reply. but here i am maintaining manually. i need to insert the data from Excel to View..

Regards,

Pavan

Re: Insert entry to a view

Former Member — Tue, 29 Sep 2009 11:58:54 GMT

Solved by myself...

Re: Insert entry to a view

Former Member — Tue, 29 Sep 2009 12:01:10 GMT

Hello

You can not insert data into view directly because view is SQL operation (create with conditions) not a table.

If you inserted to table TRUG why are you not able to insert data into TRUGT ?

You have error ?

When you insert data into TRUGT that record will be in z-view.