[Gotcha!] Calc returning wrong string value
[image unavailable: Images] Today I debut a new category: Gotcha! Devoted especially to revealing those moments which at the time they happen you are fervently hoping the world is not peeking over your shoulder. Like the time I backed into my parents garage and took the garage door down in a huge crash because I forgot I had two four-wheelers loaded in the back of my truck. It was just my luck that half the neighborhood seemed to be out for a walk past our house that day.
About seven years ago (in Servoy years) I posted this post which listed a number of my favorite Servoy gotchas. Jim C. from down the road here got all of the answers right as I remember in the comments section. And as Marcel at Servoy World 2005 aptly demonstrated in a fascinating sessionthere are so many more embarrassing moments to discuss!
So to all of you...and meI devote this category. No longer will you have to live with those hidden deep dark moments when Servoy slapped you down in a particularly embarrasing way. In the name of therapy, send your "moments" to me so the world can read about it. You'll feel better...really. Better yet, tell me about someone else's "moment" and you'll feel even better!
(Special note: I am paying major royalties in beer for anonymous tips that catch Bob Cusick or Jan Aleman out.)
Today's Gotcha! is best described by quoting the original email to me:
======
3 fields, all in same table: rct_softcredit (num), rct_notes (text) and rct_notesview (calc: text).
rct_notesview:
if (rct_softcredit > 0)
{ return 'woof ' + rct_notes
}
It returns the contents of rct_notes. Where's 'woof'?
This is where it is eventually going:
if (rct_softcredit != 0)
{ return softdonor_to_contact.con_organization + ' | ' + rct_notes;
}
======
Help locate the missing dog. Post your answer in the comment section!
Comments (3)