I have a simple SelectFrom where I am getting all of the AMBomMatl items (joining them with the Operation and BomItem tables) who’s ItemClassID equals ‘811’, but for some reason I am not getting any results. When I look through the var object results I only noticethe ‘Single row was requested’ error which to be honest I don’t know what it means.
I have been following this documentation but with no luck. I have done other SelectFrom’s before with success but not this for some reason. Any ideas?
