Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Thu, Apr 18 2019 6:46 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Can we have an extra function - FieldChanged(fieldname) returns TRUE / FALSE Its possible to code without it eg WHEN (OPERATION = 'Delete') OR (COALESCE(NEWROW._fkBanks,0) <> COALESCE(OLDROW._fkBanks,0)) OR (COALESCE(NEWROW._Income,0) <> COALESCE(OLDROW._Income,0)) OR (COALESCE(NEWROW._Expenditure,0) <> COALESCE(OLDROW._Expenditure,0)) but 1. It would read / scan a lot better 2. I'm lazy 3. I seem unable to type COALESCE correctly at the first attempt 4. Did I mention I'm lazy Roy Lambert
Tue, Apr 23 2019 1:15 PM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << Can we have an extra function - FieldChanged(fieldname) returns TRUE / FALSE >> Yes, that I can probably do. Tim Young Elevate Software www.elevatesoft.com
Tue, Apr 23 2019 3:08 PM	Permanent Link
Terry Swiers	<< Can we have an extra function - FieldChanged(fieldname) returns TRUE / FALSE >> I second (and third) that request.
Wed, Apr 24 2019 7:16 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim a) thank you b) I forgot a reason - you need separate tests depending on the OPERATION() eg OLDROW does not exist for Insert. Roy Lambert