There is something weird happening in DW rowfocuschanged event. I simply pass a key like dw1.retrieve(key) which works sometimes and sometimes not(compiled version).
I do reset the dw before I pass the key. I have debugged and checked this several times and still can't figured it out. I usually click the row to pass the key which goes in there to retrieve the data. This works well in Powerbuilder classic (code) BUT when I compile it sometimes works and sometimes not and this happens in the complied version. It retrieves the right number of rows but the actual data is replaced by zeros and ones - both fields numbers. It's just a simple dw1 retrieve.
I am using PowerBuilder 2019 R3 with DB2.