A database view that affects the underlying data?!
-
Brisingr Aerowing wrote:
Whoever wrote that view needs to be drawn and quartered. Then each piece quartered again. Then those chunks dumped into a lava pit.It's called a VIEW for a reason, people!
I am thinking it isn't actually the developer of the view but the dev of the queries for the view. A view can't actually change the data as it is or its not a "view" per say, but any idiot could have put some insertion or anything with in a query that is accessed when a view is accessed. Granted, probably the same developer but not necessarily.
Computers have been intelligent for a long time now. It just so happens that the program writers are about as effective as a room full of monkeys trying to crank out a copy of Hamlet. The interesting thing about software is it can not reproduce, until it can.
Or even better: Some triggers.
The language is JavaScript. that of Mordor, which I will not utter here
This is Javascript. If you put big wheels and a racing stripe on a golf cart, it's still a fucking golf cart.
"I don't know, extraterrestrial?" "You mean like from space?" "No, from Canada." If software development were a circus, we would all be the clowns. -
Eddy Vluggen wrote:
You expect the same results, or new ones?
As another said it depends. Not all vies are static and will report on new data rather than a slice. Depends on how the view was built, but that is not what the OP is really about. It sounds more like a view was causing the data to actually change meaning a query was doing adding to the data set which is against all view policies.
Computers have been intelligent for a long time now. It just so happens that the program writers are about as effective as a room full of monkeys trying to crank out a copy of Hamlet. The interesting thing about software is it can not reproduce, until it can.
N_tro_P wrote:
It sounds more like a view was causing the data to actually change meaning a query was doing adding to the data set which is against all view policies.
A view does not have side-effects. Adding a row is not the same as a view with side-effects :)
Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^][](X-Clacks-Overhead: GNU Terry Pratchett)
-
Then the only possibility I can think of is if some idiot (IMHO) has created a trigger on the view.
Wrong is evil and must be defeated. - Jeff Ello
SQL Server doesn't let you create a trigger that fires on a
SELECT.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
SQL Server doesn't let you create a trigger that fires on a
SELECT.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
Quite right you are. :doh: I need to get rid of this cold. My brain is getting mushy.
Wrong is evil and must be defeated. - Jeff Ello
