Actions
Support #74
closedUpdated Phone Number Not Displaying in Address
Description
rr no 6717
Phone Number Not Visible in Address After Update( delete duplicate row also)
complaint logged by pramila moodabidri
Actions
Added by Anju Mathew 17 days ago. Updated 10 days ago.
Description
rr no 6717
Phone Number Not Visible in Address After Update( delete duplicate row also)
complaint logged by pramila moodabidriselect * from consumer where rrno='6717'
select top 10* from ConsumerPhoneDetails where consumerid=6673
--update ConsumerPhoneDetails set LocalNumber= 7760590979 where consumerid=6673
select top 10 * from ConsumerAddressDetails where consumerid=6673
--UPDATE ConsumerAddressDetails
SET StreetName = 'kadlakere ontikatte moodbidri ,PH:-7760590979'
WHERE consumerid = 6673;
select * from ConsumerAddressDetails where consumerid=6673
--UPDATE ConsumerAddressDetails
SET addresscategoryid =5
WHERE consumerid = 6673;
correction done in consumer profile