I've got a project zipped up with the files necessary to reproduce this. If you'd like, I can send it to you. It's around 38MB's though... I can send it to you on a CD it you'd like - just need an address. I can also try to email it if you'd like.

You asked for a "small" project. In this case, there is something related to the size of the tables. If I delete all the records and make it small, the problem goes away.


>Hi Howard,
>
>When do you get this error, on CREATE SQL VIEW command or on USE command?
>
>Could you put small, but complete repro together? The repro should create .DBC, create tables, add some data (if required in order to get the error), create the view, ...
>
>Thanks,
>Aleksey.
>
>
>>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?