General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL select update to VFP 9 How to fix it
Environment versions
Network:
Windows 2003 Server
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
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