The troublesome field disappeared again, in spite of the fact that its name was now "User-ID." So I decided to start over. I copied the form over to a new one, but still got "USER_X": invalid identifier," when I tried to save a record.
So I started from scratch with a totally new form, and copied the fields over, except for the trouble-maker. It I created from scratch. SO FAR this has worked, but I'm still feeling apprehensive. Thank you, everyone who replied with suggestions and info. Dwayne ---- Original message ---- >Date: Thu, 21 May 2009 08:11:59 -0500 >From: "Grooms, Frederick W" <[email protected]> >Subject: Re: Missing field’s ghost haunti ng form -OOOPS! >To: [email protected] > >No the SQL view is what I was talking about not the T table > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[email protected]] On Behalf Of Dwayne Martin >Sent: Thursday, May 21, 2009 8:05 AM >To: [email protected] >Subject: Re: Missing field’s ghost haunti ng form -OOOPS! > >Frederick, > >What do you mean by "Delete the database view"? Delete the T1766 table in the >database? Sounds scary but I'll try it if you say so. I tried deleting the >SQL view, but it didn't help. > >Dwayne > >---- Original message ---- >>Date: Wed, 20 May 2009 15:41:07 -0500 >>From: "Grooms, Frederick W" <[email protected]> >>Subject: Re: Missing field’s ghost haunti ng form -OOOPS! >>To: [email protected] >> >>Delete the database view and add a new dummy (optional) field to the form. >>ARS should re-create the database view whenever a database field is added or >>removed from the form. >> >>-----Original Message----- >>From: Action Request System discussion list(ARSList) >>[mailto:[email protected]] On Behalf Of Dwayne Martin >>Sent: Wednesday, May 20, 2009 3:35 PM >>To: [email protected] >>Subject: Re: Missing field’s ghost haunting form -OOOPS! >> >>I spoke too soon. >> >>Whenever I try to save an entry I still get "ARERR [552] Failure during SQL >>operation to the database : ORA-00904: "USER_X": invalid identifier," even >>when I delete the field entirely. >> >>So I guess my only choice is to start over with a new form. >> >>Dwayne >> >>
