justin wrote:
Adrian Klaver wrote: ----- "justin" <justin@emproshunts.com> wrote:
So it appears that something is causing _wipvalue to get set to NULL somewhere else in the code. Now when running the failing select statement manually works is because the modified record is still not committed yet and its reading the unmodified record.
the ForceCloseWo() calls several other functions before PostProduction() that beat on the header record a few times. ForceCloseWo does extactly what it sounds like closes Work Orders forcible based on default values set in the database. I'm betting this record has some flaky setting somewhere thats either in the posting of raw material or labor operations.
its late i'm going to bed fight this again later this morning.
thanks
Found the problem at last. it was what i thought early this morning, the database had some flaky data set to null. so modified the the tables in question set defaults to zero and updated all the records that has null to zero. hopefully that fixes the problem going forward.
thanks to all for helping, pointing me in the right direction to figure out what is going on, as i was completely lost of what next to do.