Notifications
Clear all
Topic starter
I am wondering if someone could please help with this SQL query:
Update RPTOBS set obsvalue = 'given' where obsvalue = 'copied' and hdid = 244877
I only return: Msg 4406, Level 16, State 1, Line 1
Update or insert of view or function 'RPTOBS' failed because it contains a derived or constant field.
Basically, I want to be able to change the erroneous values and garbage data that has been entered for certain observations. That's possible with the appropriate SQL query, right?
Thanks so much
Posted : October 15, 2015 11:17 am
RPTOBS is a view, not a table. The table that holds observation values is OBS.
Good luck!
Posted : October 15, 2015 11:48 am
I agree with Stephen, I have fixed the Obsvalue on a few different Obs Terms and I have always used the Obs Table. You should be able to replace "RPTOBS" with "OBS" in your update statement.
Posted : October 16, 2015 5:33 am
Topic starter
oh, I get it.
Thanks so much for pointing that out!
Posted : October 19, 2015 4:03 am
