General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
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.
>Hmmmm...
>
>Can't find any bugs in our database related to this and I also can't repro using any of the tables or view from the Northwind database. Ummm...there should be spaces between the end of the lines and the semi-colon but that's probably just the way it went into this post?
>
>Could you go to the VD, right-click to pull up SQL, and cut and paste the exact SQL? Thanks.
>
>
>
>>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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only