M
marian.edu
Guest
Man, one need to really review all code that uses temp-tables… there really seems to be (not so) funny issues there 
Anyway, I find it odd for TS to advise on using RELEASE while I think that should just be deprecated because it it’s totally misleading when it comes to transaction scope… if it must use VALIDATE. Back to the sample, there is probably something wrong with the way temp-table indexes are implemented… if you take out the second index (the multi fields one) the record is found, if you leave the index but then remove the check on b_paruj.rekon_id EQ 0 the record is again found and much to one surprise the value of that field is indeed 0. The explanation would be the index record was not created because no value was set for one of the index fields, then the for loop uses (rightful) the multi-field index but there is no record created in that index 
Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212
Continue reading...
Anyway, I find it odd for TS to advise on using RELEASE while I think that should just be deprecated because it it’s totally misleading when it comes to transaction scope… if it must use VALIDATE. Back to the sample, there is probably something wrong with the way temp-table indexes are implemented… if you take out the second index (the multi fields one) the record is found, if you leave the index but then remove the check on b_paruj.rekon_id EQ 0 the record is again found and much to one surprise the value of that field is indeed 0. The explanation would be the index record was not created because no value was set for one of the index fields, then the for loop uses (rightful) the multi-field index but there is no record created in that index Marian Edu Acorn IT www.acorn-it.com www.akera.io +40 740 036 212Continue reading...