Brilliant, that works like a charm Darren.
Does this variable affect non dynamic sql statements aswell?
If we set this variable will we see a performance hit?
After a little more investigaion and a bit more reading, I've found out ProIV only SELECTs fields used in the function for the primary file, for all secondary files all fields are selected.