Thanks, Jason. I googled "oracle sql keywords" and compared it to my query of field names from my form. I found a field named "create" and one named "modify", so I renamed them. That didn't work. So I renamed fields with more than one word in the name if one of the words was a key, like "Date needed". But still no luck.
My list of keywords may not be complete. It doesn't include "Function". I don't have a field with that name, but there might be other bad ones not on the list. Dwayne ---- Original message ---- >Date: Wed, 13 Feb 2008 12:19:30 -0800 >From: Jason Miller <[EMAIL PROTECTED]> >Subject: Re: Form sql view not found >To: [email protected] > > ** > Do you have any fields that are the same as SQL > keywords? I remember years ago having form that > would give us a message that the view could not be > created when we imported the def. Turns out there > was a field called Function and MS SQL was getting > hung up on it. Once we name the field Function1 the > view would create. > > Jason > > > On 2/13/08, Dwayne Martin <[EMAIL PROTECTED]> wrote: > > Thanks, Fred. I tried that but got: > > "Creation of one of the SQL views for the form > failed within the SQL database. > Operation completed successfully, but the SQL view > is not in place. (ARWARN 69)." > > Dwayne > > ---- Original message ---- > >Date: Wed, 13 Feb 2008 10:39:50 -0600 > >From: "Grooms, Frederick W" > <[EMAIL PROTECTED]> > >Subject: Re: Form sql view not found > >To: [email protected] > > > >Add an optional field to the form and ARS should > re-create the view. > >Anytime you add or remove fields from a form the > Remedy server will drop > >and re-create the database view. > > > >Fred > > > >-----Original Message----- > >From: Action Request System discussion > list(ARSList) > >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne > Martin > >Sent: Wednesday, February 13, 2008 10:22 AM > >To: [email protected] > >Subject: Form sql view not found > > > >Hello Everyone, > > > >We have a form named "LA:SoftwareInstall." For > years we have queried > >the database using the view name > "la_softwareinstall." Now that view is > >no longer present. If I look at a list of all > our views on the database > >(Oracle 10.2 db) I see views for the other forms, > but nothing resembling > >"la_softwareinstall." It is missing in both our > test and live > >databases. > > > >Last year we copied our existing database to a > new server, then > >installed the 7.1 ARS system on top of it. Is it > possible that the > >"la_softwareinstall" view somehow got left behind > in the database copy? > > > >Is there an easy way to get it back again? I > know we could use a > >complicated "create view" statement directly in > Oracle, but would that > >even be wise? > > > >Dwayne Martin > >James Madison University > > > > >_______________________________________________________________________________ > >UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org > >Platinum Sponsor: www.rmsportal.com ARSlist: > "Where the Answers Are" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at > www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: > "Where the Answers Are" > > __Platinum Sponsor: www.rmsportal.com ARSlist: > "Where the Answers Are" html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
