Hej Peter..

The VFP view you refer to - is it a local view or a remote view? If it is a remote view, where is your data ultimately stored?

I just tested this with pure VFP data. The field remains a character type.

Let's break this down step by step...