Hi Howard,

Try to e-mail it to me with instructions what to do to reproduce the error.

Thanks,
Aleksey.

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