Sometimes I to need all records where Field A is greater the Field B.
These are just a one time need for me.
Is there a way to do this with having to right a looping script or a quick boolean calculation?
make a new FieldC as a stored calculation that returns number and the calculation of FieldA>FieldB
Find on FieldC = 1
This will only work if FieldA and FieldB are numerics.
Did you mean "without having to write a looping script or a quick Boolean calculation"? The answer is yes, sort of: you could use the ExecuteSQL() function to get the unique IDs of such records, then use this in a find or GTRR. Would this be less work than writing a looping script or a quick Boolean calculation? I doubt it.
coherentkris wrote: This will only work if FieldA and FieldB are numerics.
It will work with all data types (except maybe container fields, haven't tested that).
Retrieving data ...