In the SQL Documentation, it says that SQL Views cannot contain the ORDER BY parameter as well as a few others which are native to the SQL language (at least in VFP). If that is the case, how do you return an ordered view. Do we have to run the view without an order and then build an index for it? Does anyone know if the upsizing wizard that VFP has will automatically create the solution? Seems odd that in saying that views don't allow ORDER BY, that the alternative for how you handle it would not have been explained. Anyway, would appreciate any insight you have to this question.

TIA,

Bill