>in a table I have a field named CustType, which can only have 4 values: Q, W, E, R
>
>I want to sort the table by CustType, but neither in ascending(EQRW) nor descending(WRQE) order, I want the order to be Q,W,E,R. Is it possible?
>
>Are there any VFP commands can do this?
>Is it possible to sort the table in this order, when I'm selecting data with SQL statement?
>Which way is better?
a) Create a cursor CustTypes and populate it with
CustType OrderPos
-------------------
Q 1
W 2
E 3
R 4
b) Cross tables, using the order set in the types cursor
SELECT Customers.* ;
FROM Customers ;
INNER JOIN CustTypes ON CustTypes.CustType = Customers.CustType ;
ORDER BY CustTypes.OrderPos
----------------------------------
António Tavares Lopes