Actually Drops and Creates do not require Commits as they are DDL type transactions. I have had the problem where I did a copy/paste from a display only field and changed it to a actual field (with different ID). For some reason it did not save the actual field column to the db and the db view did not get created.
The reason(s) they probably do not use the Create or Replace format for views are: 1. The rename of a form 2. I don't know if all databases supported allow the Create or Replace command. Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Monday, February 22, 2010 2:18 PM To: [email protected] Subject: Re: Remedy View Validation W.R.T. costs, not a shred of difference.. Since the commit happens after the creating the new view, and not immediately after the drop, I would assume the old view is still valid, until the commit after which the new view becomes active?? Create or Replace would only perhaps save the need for dropping it? But Remedy probably doesn't prefer that because of the possibility of an actual form rename, in which case a drop would be necessary before creating a new one.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Rick Cook Sent: Monday, February 22, 2010 3:07 PM To: [email protected] Subject: Re: Remedy View Validation Ok, so it drops and recreates views. Is that really a bad thing? Rick -----Original Message----- From: "Grooms, Frederick W" <[email protected]> Date: Mon, 22 Feb 2010 14:03:10 To: <[email protected]> Subject: Re: Remedy View Validation No BS. I just ran a test ... It DOES delete and create the View. I simply added a field to a dummy form as a test and looked at the SQL log. This is on Solaris w/Oracle. Action Request System(R) Server Version 7.1.00 Patch 008 200911120530 (c) Copyright 1991-2007 BMC Software, Inc. <SQL > <TID: 0000000004> <RPC ID: 0000000727> <Queue: Admin > <Client-RPC: 390600 > <USER: me > /* Mon Feb 22 2010 13:54:12.4877 */DROP VIEW Template <SQL > <TID: 0000000004> <RPC ID: 0000000727> <Queue: Admin > <Client-RPC: 390600 > <USER: me > /* Mon Feb 22 2010 13:54:13.0786 */OK <SQL > <TID: 0000000004> <RPC ID: 0000000727> <Queue: Admin > <Client-RPC: 390600 > <USER: me > /* Mon Feb 22 2010 13:54:13.0792 */CREATE VIEW Template (Request_ID,Submitter,Create_Date,Assigned_To,Last_Modified_By,Modified_Date ,Status,Short_Description,Real_Number_Field,History,Keywords,Date_Time_Field ,Date_Field,Start_Time_Field,Time_Field,JUNK) AS SELECT T25.C1,C2,C3,C4,C5,C6,C7,C8,C520000001,C536870915,C536870916,C540000054,C560 000001,C560000002,C560000003,C560000006 FROM T25 <SQL > <TID: 0000000004> <RPC ID: 0000000727> <Queue: Admin > <Client-RPC: 390600 > <USER: me > /* Mon Feb 22 2010 13:54:13.1550 */OK Fred -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Monday, February 22, 2010 1:49 PM To: [email protected] Subject: Re: Remedy View Validation ** Views, it replaces.. It uses the syntax Create or Replace view as blah blah blah.. If present it just replaces - if absent it creates.. Tables like Rick says, it used to rename, create a new one, copy data from renamed table to new table, drop old.. Right now I'm not exactly sure what it does when you alter table, maybe it just issues the good old alter table statement?? Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Rick Cook Sent: Monday, February 22, 2010 2:42 PM To: [email protected] Subject: Re: Remedy View Validation ** I cry BS, too. Remedy USED to drop forms when a field was deleted, but I don't think even that happens any more. Rick -----Original Message----- From: Tommy Morris <[email protected]> Date: Mon, 22 Feb 2010 13:36:04 -0600 To: <[email protected]> Subject: Remedy View Validation AR 7.5p1 Oracle 11g We had a custom view built against HPD_Help Desk to facilitate external reporting. This view was recently dropped and then recreated by some "unknown entity" (I blame the kittens). When I asked our dba's about this they responded that the Remedy Application drops views and recreates them when a new field is added or moved around (customizing form views through Developer/ Admin tool). I of course cried BS but just wanted to ask the list; Has anyone seen where modifying a form causes database objects to drop and recreate? Tommy Morris _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
