Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP9 - SQL Too Complex???
Message
 
To
18/02/2005 13:37:00
Luis Navas
Independent Consultant
Auckland, New Zealand
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00988402
Message ID:
00988431
Views:
58
It says it doesn't 'recognize' SELECT *.pbrmain... as valid...

>Try
>>SELECT *.pbrwork, *.pbrmain;
>> FROM ;
>> mc!pbrwork ;
>> INNER JOIN mc!pbrmain ;
>> ON Pbrwork.pbrmainfk = Pbrmain.primarykey;
>> WHERE Pbrwork.pbrmainfk = ( ?lnPBRMainFK );
>> ORDER BY Pbrwork.pbrmainfk, Pbrwork.linenumber
>
>
>Luis Navas
>
>>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
Map
View

Click here to load this message in the networking platform