Topic: report error
good day, other question, related this time to report. i'm trying to execute the "Survey Details" from Report Browser in Datawarehouse, selecting the survey, enabling the vague date and final to download select but i get this error:
general_errors.There was an SQL error: ERROR: cannot update view "cache_occurrences" DETAIL: Views that do not select from a single table or view are not automatically updatable. HINT: To enable updating the view, provide an INSTEAD OF UPDATE trigger or an unconditional ON UPDATE DO INSTEAD rule. - UPDATE "cache_occurrences" SET "downloaded_flag" = 'F' WHERE ("id" IN ('5169','5121','5122','5170','5123','5171','5124','5172','5125','5173','5126','5174','5127','5128','5129','5130','5131','5133','5134','5135','5136')) AND "downloaded_flag" = 'I'
is there anything i could fix on my own or any clues to make it work?
thanks
QuestIT s.r.l.
Home page: www.quest-it.com
E-Mail: politi@quest-it.com - Skype: carlo.politi.questit