Do you have any workflow that triggers on a Window Open that might be changing the Remedy value?
________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Shafqat Ayaz Sent: Friday, April 27, 2007 11:19 AM To: [email protected] Subject: SQL Problems ** Hi Listers I am having a strange problem, maybe some guru out there can shed some light on it. I have a form with 3 fields, these are drop down list fields, the values are Red, Amber, and Green. I have another field which is a character field named Project TL ( Traffic light). On Save some workflow runs which looks at the 3 fields and sets the value of the Project TL field, for example if there is any field Red, then the value in the Project TL is set to Red, characters not an integer value. Now on the Remedy form, this field shows the value correctly, after every save and Window Open, but if I run a SQL query, the value in the field is the last value that the field was set to. For example on the form the field is set to Red, I then change the other fields to say Amber, the value remains at Red in the database, but in the field on the form it shows Amber. I then change the value to Green, the value on the form in the field shows Green, the value in the database shows Amber!! any ideas will be very welcome, and as usual please accept my thanks in advance ARS 7.0.01 patch 001 SQL 2005 - 9.00 Windows NT User Tool/Admin Tool same as server thanks shafqat Shafqat Ayaz "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.." ________________________________ Ahhh...imagining that irresistible "new car" smell? Check out new cars at Yahoo! Autos. <http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html; _ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM -> __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
