Thanks Misi,
I walked away, and it started to work. Miracles!!!!
The command is
On Submit/Modify
Runif: ('DB.Field' != 'Field') AND ('Field2' = $NULL$) AND ('Field' != $NULL$)
Message: STOP
Sincerely,
D.Dussie
On Apr 7, 2011, at 3:09 PM, Misi Mladoniczky <[email protected]> wrote:
> Hi,
>
> First you need to understand what the transaction value is.
>
> The transaction value is typically NULL, if not changed. For example if
> the user saves a modified record and has changed other fields.
>
> It can also be the same value as the database value if it is sent via
> Push-Fields or Modify-All, but is not really changed.
>
> This means that ('TR.Field' != $NULL$) does not always indicate a change.
> This means that ('TR.Field' != 'DB.Field') does not always indicate a change.
>
> The best way to be 100% sure of changed value is ('Field' != 'DB.Value).
> This works should work in all cases, but I have seen problems when using
> Currency-Fields...
>
> Describe to us what you want to do, the result you expect and the result
> you are seeing.
>
> Best Regards - Misi, RRR AB, http://www.rrr.se
>
> Products from RRR Scandinavia (Best R.O.I. Award at WWRUG10):
> * RRR|License - Not enough Remedy licenses? Save money by optimizing.
> * RRR|Log - Performance issues or elusive bugs? Analyze your Remedy logs.
> Find these products, and many free tools and utilities, at http://rrr.se.
>
>> Has anyone experienced an issue with developer studio 7.5p6 or filter
>> transaction involving a runif qualification not calculating?
>>
>> Tried:
>> Runif: 'DB.Field1'!= 'TR.Field1'
>> Setfield: Field2 = db value is not equal to transaction value
>> Esle: Field2 = db value is equal to transaction value
>>
>> Field1 database value = test
>> Field1 transaction value = test1
>>
>> Tried:
>> Runif: 'DB.Field1'!= 'Field1'
>> Setfield: Field2 = db value is not equal to transaction value
>> Esle: Field2 = db value is equal to transaction value
>>
>> This worked in 6.3p20, and existing workflow from 6.3 is working in the
>> versions
>>
>> Ars 7.5p4
>> Db 10g
>> Devstudion 7.5p6
>> Wut 7.5p7
>> Aix 6.1
>>
>> Sincerely,
>> D.Dussie
>>
>> _______________________________________________________________________________
>> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
>> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
>>
>
> _______________________________________________________________________________
> UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
> attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"
