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