My use of views is extremely limited, but I thought I read somewhere that the ?variable had to exist for a view in VFP9 to be 'valid'.
good luck
>You're right - that does make more sense...but...it didn't help any. Still getting the SQL too complex message...
>
>>I think he meant:
>>
>>
>>Select pbrwork.*, pbrmain.*
>>
>>
>>Richard
>>
>>
>>>It says it doesn't 'recognize' SELECT *.pbrmain... as valid...
>>>
>>>>Try
>>>>>SELECT *.pbrwork, *.pbrmain;
>>>>> FROM ;
>>>>> mc!pbrwork ;
>>>>> INNER JOIN mc!pbrmain ;
>>>>> ON Pbrwork.pbrmainfk = Pbrmain.primarykey;
>>>>> WHERE Pbrwork.pbrmainfk = ( ?lnPBRMainFK );
>>>>> ORDER BY Pbrwork.pbrmainfk, Pbrwork.linenumber
>>>>
>>>>
>>>>Luis Navas
>>>>
>>>>>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?