Dale, I think this would not capture if I am setting the field from a some
value to NULL value.
As, I still want this entry in the Audit Log - Value changed from A to
.....(BLANK)
Just that, I want to avoid capturing NULL to NULL which is not relevant for
me.
On Monday, December 3, 2012 8:43:09 PM UTC-8, Raj wrote:
>
> ** Thanks Dale. Based on lot of discussions on this topic, I decided not
> to involve TR to avoid any complexities.(In-spite of benefits of using TR)
> but looks like I would have to give that a try.
>
> Also, I was thinking to try something like below:
> ('field' != 'DB.field') AND ('field' != "")
>
>
> On Monday, December 3, 2012 5:44:10 PM UTC-8, Dale Jones wrote:
>>
>> **
>> Try
>> 'TR.field' != 'DB.field' AND 'TR.field' != $NULL$
>>
>> Dale Jones
>> DCS
>> Raleigh, NC
>> 919-523-6034
>> ------------------------------
>>
>>
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
"Where the Answers Are, and have been for 20 years"
