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"
