Updating View to solve erp error

Posted by Kvenkat4025 under Sql Server on 6/26/2013 | Points: 10 | Views : 498 | Status : [Member] | Replies : 2
Hi,

I have view like

create view item_group_master_vw
--(lo_id,group_code,group_desc,group_type,category,usage,attribute,item_code,variant_code,status,createdby,createddate,modifiedby,modifieddate)
as
select
a.item_igt_lo as lo_id,
item_igi_groupcode as group_code,
item_igm_groupdesc as group_desc,
item_igt_grouptype as group_type,
item_igm_category as category,
item_igm_usage as usage,
item_igm_attribute as attribute,
item_igi_itemcode as item_code,
item_igi_variantcode as variant_code,
item_igm_status as status,
item_igm_createdby as createdby,
item_igm_created_date as createddate,
item_igm_modified_by as modifiedby,
item_igm_modified_date as modifieddate
from item_group_master a (nolock),item_group_byitem b (nolock)
where a.item_igm_groupcode = b.item_igi_groupcode

In this View am updating this item_group_master_vw.
------------------

update item_group_master_vw
set
group_code ='EXPGRP1'
where item_code='30300023'
go

The table has been updated ,but it will not solve front end error.

Please do need full..

Thanks

K.Venkat

k.venkat


Responses

Posted by: Bandi on: 7/29/2013 [Member] [MVP] Platinum | Points: 25

Up
0
Down
Can You post the error message which you got through application?

Mark This Response as Answer
--
Chandu
http://www.dotnetfunda.com/images/dnfmvp.gif

Kvenkat4025, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ssj_Kumar on: 7/30/2013 [Member] Starter | Points: 25

Up
0
Down
Your View holds the Groupcode which present in both item_group_master and item_group_byitem but you updating only item_group_master Groupcode might be that groupcode will not be in item_group_byitem or you need to refresh your view



Regards,
Jayakumar Selvakani

Kvenkat4025, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response