Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Parameterized view and multiple tables Prob.
For the first time I need to create a parameterized view utilizing > 2 tables and am not succeeding. (I'm using the view designer but have also tried to create the view from the command line without success.)
I need to create a parameterized view on a parent table "Group". Additionally I need the view to include one field each from three other tables. (There is only a single child record in each.) When I try to save the my view I get a message, "SQL: Column 'GROUPKEY' is not found.". The message() function returns "Variable 'GROUPKEY' is not found.".
I'm sure I'm overlooking something rather simple. The view designer's SQL statement follows.
Help anyone?? Thanks
SELECT Group.groupkey, Group.suffix, Groupname.groupname,;
Groupnum.groupnum, Notedata.textnote;
FROM mhngroup!groupname LEFT OUTER JOIN mhngroup!group;
LEFT OUTER JOIN mhngroup!groupnum;
LEFT OUTER JOIN mhngroup!notedata ;
ON Notedata.groupkeyid = Group.groupkey ;
ON Groupnum.numkey = Group.numkey ;
ON Groupname.namekey = Group.namekey;
WHERE Group.groupkey == ?thisform.CurrentGroupKey;
AND Group.suffix == ?thisform.CurrentGroupSuffix
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