Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL select update to VFP 9 How to fix it
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL select update to VFP 9 How to fix it
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01188473
Message ID:
01188473
Views:
65
SELECT Customer.code, Min(Ordhead.daterequired),Max(Ordhead.daterequired) ;
FROM frantisi!ordhead, Customer ;
WHERE OrdHead.CustomerID= Customer.CustomerID ;
GROUP BY /customer.code ;
ORDER BY DateRequired ,Customer.Code ;
INTO cursor Temp

above query works fine in VFP7 but fails with "Order by clause is invalid"

How do I fix it?
Mike
Next
Reply
Map
View

Click here to load this message in the networking platform