My knowledge of views has been increasing over the last few days - trying to figure this out - but I'm still a real novice about these things...

The variable is declared and does exist when the code is run. I have many other views for which I use the same variable scenario and they work just fine in VFP9 View Designer.

Thanks.

>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?