I thought that too - I took them out - no change - still too complex...If I recreate the view in VFP9, it puts the parentheses in as well.

This view worked in VFP8 as is - just not in VFP9.


>Howard
>
>This is a parameter view, judging by the ?lnPBRMainFK, but why the parenth. around it, why not just:
>
> WHERE Pbrwork.pbrmainfk = ?lnPBRMainFK ;
>
>
>>I'm trying to upgrade my app to VFP9 from VFP8. It's giving me the "SQL expression is too complex" on this view:
>>
>>SELECT *;
>> FROM ;
>> mc!pbrwork ;
>> INNER JOIN mc!pbrmain ;
>> ON Pbrwork.pbrmainfk = Pbrmain.primarykey;
>> WHERE Pbrwork.pbrmainfk = ( ?lnPBRMainFK );
>> ORDER BY Pbrwork.pbrmainfk, Pbrwork.linenumber
>>
>>Any ideas?