John Robson

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?

CHeers

JOhn

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.

Looks like we'll have to split the filedefs.

Thanks for your help.

Cheers

John

Cheers for that chris