Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB Enhancement Requests and Suggestions » View Thread |
Messages 1 to 4 of 4 total |
SQL/PSM |
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 |
This web page was last updated on Friday, April 19, 2024 at 07:09 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |