When populating columns in a grid, I have some code that goes like this:
.column1.controlsource=iif(cust.type='R','rfinan.acct','lfinan.acct')
This works for 99% of my customers. However 1 customer complained that this column did not show anything. He sent me his data and sure enough it showed nothing. After pulling my hair out for about an hour inspiration struck and I chaged the code to read:
.column1.controlsource="iif(cust.type='R',rfinan.acct,lfinan.acct)" and it now works everywhere.
Question: Why did the first version ever work?
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!