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