Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Chaining Left Outer Joins?
Versions des environnements
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
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement