General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
I thought that too - I took them out - no change - still too complex...If I recreate the view in VFP9, it puts the parentheses in as well.
This view worked in VFP8 as is - just not in VFP9.
>Howard
>
>This is a parameter view, judging by the ?lnPBRMainFK, but why the parenth. around it, why not just:
>
> WHERE Pbrwork.pbrmainfk = ?lnPBRMainFK ;
>
>
>>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
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