Chris,

Is the view designer giving you the error?

If so you might try using eview available here in the files section or just create this view in code using CREATE SQL VIEW and forget about the limitations the view designer imposes.

>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