I'm trying to create a local view by chaining a few Left Outer Joins in grandparent-parent-child fashion. The join fields are all non-null integer primary keys, with the parent key in the child record (one to many). The VFP view designer builds, displays, saves, loads and browses correctly, but when I use the view in actual code, it throws error 1494: view definition has been changed.

The error occurs as soon as a second LOJ is added, even if no fields from the child table are added. I've tried NVLing to integer values, but that doesn't work. How can I get view that VFP is giving me available in the program without an error?

SELECT grand.grandid, parent.parentid, child.childid ;
FROM mydbc!grand ;
LEFT OUTER JOIN mydbc!parent on grand.grandid = parent.grandid ;
LEFT OUTER JOIN mydbc!child on parent.parentid = child.parentid