Thanks everyone. I'll test this out now. Didn't want to put forth the effort in creating this if I might not be able to make updates. (I have to get our DB guy involved to create the view for me).
I really appreciate the feedback! Going to my very FIRST WWRUG this year and I cannot wait to meet everyone! Lisa ________________________________ From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Wednesday, September 01, 2010 5:20 PM To: [email protected] Subject: Re: View Forms ** Some of the joins that Remedy creates when you create joins are extremely inefficient as far as performance is concerned. I wish I had a ready example but I don't We had re-written these to more efficient UNION joins after creating them from the Admin interface. Re-writing the join doesn't break the original form so long as the join has all the fields referenced. All queries including updates worked after I had this done.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of LJ LongWing Sent: Wednesday, September 01, 2010 5:13 PM To: [email protected] Subject: Re: View Forms ** I know there is some sort of limit on modifying/deleting records if there is a join/union involved....don't know the specifics...but best case scenario...you can try and let us know the outcome :) From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Wednesday, September 01, 2010 3:00 PM To: [email protected] Subject: Re: View Forms ** Even if it is a union you can.. Been there done that.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of LJ LongWing Sent: Wednesday, September 01, 2010 4:49 PM To: [email protected] Subject: Re: View Forms ** As long as it isn't a UNION, I think you can.... From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Kemes, Lisa Sent: Wednesday, September 01, 2010 2:28 PM To: [email protected] Subject: View Forms ** I have a rather complicated Join that I would like to do on 2 AR Forms. If I create a View (joining 2 AR Forms on the database) and put a View Form on top of it, would I still be able to change the data from the AR View Form? Lisa Kemes AR System Developer Tyco Electronics 717-810-2408 tel 717-602-9460 cell [email protected] _attend WWRUG10 www.wwrug.com ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
