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