Almost... 'FieldName' = The most current value of the field 'TR.FieldName' = The "TR"ansaction value of the field. Basically, any field that is in the SET clause of the SQL update statement. 'DB.FieldName' = The value stored in the database.
Thad Esser Remedy Developer "Argue for your limitations, and sure enough, they're yours."-- Richard Bach "McManus Michael A SSgt HQ 754 ELSG/DOMH" <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 10/04/2007 02:01 PM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: TR, DB, and nothing 'FieldName' = Current value of the field 'TR.FieldName' = Current value of the field if it has changed, else the value is null. 'DB.FieldName' = Value stored in the database. Obviously, this value does not exist on submit. Michael A. McManus, SSgt, USAF Remedy Developer HQ 754 ELSG/DOMH DSN: 596-6478 / Comm: 334-416-6478 -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Cupp, Michael E CTR USAF AFRL/RYOD Sent: Thursday, October 04, 2007 3:58 PM To: arslist@ARSLIST.ORG Subject: TR, DB, and nothing Can someone explain the difference between the following: 'FieldName' 'TR.FieldName' 'DB.FieldName' Are there other prefixes out there that may be of use? If the DB. is what I think it is, it's something I've asked for, but was told didn't exist, so I have had to do extensive coding around it (Creating a dup field, setting it via work flow, comparing 2 field values, etc). Thanks! M _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" ***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.*** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"