Chris:
You have to set this field to NULL through workflow or the results of your check can and will be unpredictable.
James McKenzie
-----Original Message-----
From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Chris Akens
Sent: Thursday, July 20, 2006 1:30 PM
To: [email protected]
Subject: NULL - Erratic Behavior
List,
I have an active link that checks to see if a record is locked. It runs on Display and a Run If of ('z1d Locked By' != $NULL$).
The action is then a message of "This record is in use by $z1d Locked By$ and has been locked."
Looking at the DB table, all values in the column are NULL. However, depending on the request I open up, sometimes I receive no error message.
Others I will receive the message of
"This record is in use by NULL and has been locked."
I generally receive the NULL message when opening up tickets that are older. My only thought is that the tickets that were created before I added the 'z1d Locked By' field to the form, have some sort of minute difference in the NULL DB value.
Any thoughts?
Thanks.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
