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 outnew cars at Yahoo! Autos.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
