Information générale
Catégorie:
The Mere Mortals Framework
Titre:
Question on View Parameters
I have a cBizObjMaintForm that uses a view with the following SQL:
SELECT Personnel.*, Per_aprv.ccdtid, Per_aprv.cspedid, Per_aprv.ctermid,;
Per_aprv.cassn1id, Per_aprv.cassn2id, Per_aprv.cassn3id;
FROM personnel ;
LEFT OUTER JOIN per_aprv ON Personnel.cid = Per_aprv.cperid;
WHERE UPPER(Personnel.clastname) = UPPER(?vp_cLastName);
AND Personnel.cid = ?vp_cPerId;
AND Per_aprv.ccdtid = ?vp_cCDTId;
AND Per_aprv.cspedid = ?vp_cSpedId;
ORDER BY Personnel.clastname, Personnel.cfirstname
My selection criteria page has controls with the cViewParameter property set to each of vp_ view parameters. My problem is that only records with BOTH 'personnel' and 'per_aprv' are found. It is possible to have records in the 'personnel' table that do not have related records in 'per_aprv'.
How does the framework evaluate this line "Per_aprv.ccdtid = ?vp_cCDTId" if vp_cCDTId is empty? It seems like there must be some behind the scenes trick that would make this line evaluate to .T. that I must be missing.
BTW: The application used to use MM 4.0 and I didn't seem to have this problem. Has anything changed between MM 4.0 and MM 7.0 that would cause this behavior?
TIA
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