Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
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?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement