Hi Jim,
Look at my reply to John. There are no links or relations neither in the database nor in the DE. There is no referential integrity. Everythig refers to mt_MASTER but the view on which the grid is based that goes like
select ... from DETAIL where DETAIL.idmaster = ?MASTER.id
The problem is not that the referenct to MASTER fails. It SHOULD fail but, if MASTER is added to the DE, everything works fine. Who is moving the pointer in MASTER?
Thanks a lot.
===============================================================================
Silvio,
I would bet that setting the link column to Databasename!Master.ID would not fail. However, I woudl wonder what the from clause looks like, if it is
FROM Master mt_Master JOIN ...
then that would suggest why the later ref of Master fails, the SQL is using a local alias of mt_Master and knows nothing about any alias of Master.
Précédent
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