Re: Weird SQL issue - column missing from T table

2010-10-26 Thread Grooms, Frederick W
: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Ron Legters Sent: Monday, October 25, 2010 4:34 PM To: arslist@ARSLIST.ORG Subject: Re: Weird SQL issue - column missing from T table ** Bingo! I would swear this worked on Friday, though. Well, back

Re: Weird SQL issue - column missing from T table

2010-10-26 Thread Ron Legters
Admin -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Grooms, Frederick W Sent: Tuesday, October 26, 2010 6:57 AM To: arslist@ARSLIST.ORG Subject: Re: Weird SQL issue - column missing from T table If it is reporting

Weird SQL issue - column missing from T table

2010-10-25 Thread Ron Legters
I'm getting an error when I try to save a CRQ - ARERR [552] Failure during SQL operation to the database : Standard Change. Looking at the SQL log, the problem seems to be this: *** ERROR *** Invalid column name 'C100338' It's doing a 'select' from table T1148, which is

Re: Weird SQL issue - column missing from T table

2010-10-25 Thread Roger Medsker
Sent: Monday, October 25, 2010 4:21 PM To: arslist@ARSLIST.ORG Subject: Weird SQL issue - column missing from T table ** I'm getting an error when I try to save a CRQ - ARERR [552] Failure during SQL operation to the database : Standard Change. Looking at the SQL log, the problem seems

Re: Weird SQL issue - column missing from T table

2010-10-25 Thread Ron Legters
@ARSLIST.ORG Subject: Re: Weird SQL issue - column missing from T table ** Ron, Check in Admin to see whether this field is Display Only. If so, it will show up in all of the places you mention AND will not be a column in the T1148 table. Roger Medsker From: Action Request System discussion list

Re: Weird SQL issue - column missing from T table

2010-10-25 Thread Joe Martin D'Souza
What are the DB attributes of that field? Display-Only? Joe From: Ron Legters Sent: Monday, October 25, 2010 5:20 PM Newsgroups: public.remedy.arsystem.general To: arslist@ARSLIST.ORG Subject: Weird SQL issue - column missing from T table ** I’m getting an error when I try to save a CRQ