It seems that VFP6 allowed this SQL to give me the records that I expected, but since I have switched to VFP7, which has tighter rules regarding null values, the SQL does not produce the same results. I have rewritten the SQL and all seems to work now. Thanks for your help.


>>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
>
>What happens if you run this SELECT outside of your application and the Framework? The only thing the Framework is doing for you is storing values in the view parameters, if you've specified that it should do so.
>
>If your SELECT statement works fine outside of your application, then I recommend setting a breakpoint in your business object's Requery() method to see which values are being assigned to your view paramters.
>
>Regards,