The limit of 8192 is not exceeded
The field is a date field
That field is one of the fields selected
the order clause specifies the name of the field and not a numeric position

Additional info: In my select I do this

select date as MeaningfullNameForDate...

and the order is with MeaningfullNameForDate. That should'nt be a problem should it?


>Is it possible that you exceed VFP command limit of 8192 charaters?
>
>>I build a rather long SQL interrogation. After everything is in there I want to order it. I receive the error message mentioned in the thread title.
>>
>>I have'nt been able to find what's wrong beside that interrogation being long (over 4000 characters).
>>
>>But I really don't think it's the problem
>>
>>So as a quick fix I did my interrogation. Stored it in a temporary cursor. After that I built my real cursor and ordered this one. Everything went fine.
>>
>>Here's what I mean:
>>
>>

>>select field1, field2, field3 from WhateverTables into cursor TmpCurs
>>
>>select * from TmpCurs order by OrderNeeded into cursor NeededCurs
>>

>>
>>Anyone can tell me why I had to do this?