I've never been happy with XOJO recordsets as they seemed to sometimes return the wrong columntype
I was looking in the LR for the field types and its just clicked why that was.
idxfield is one based and columntype is zero based !
10 YEARS! 10 YEARS I've struggled to figure that out! AAARGHH!