Is OrderNeeded one of the fields (field1, field2, field3)?
>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?
.·*´¨)
.·`TCH
(..·*
010000110101001101101000011000010111001001110000010011110111001001000010011101010111001101110100
"When the debate is lost, slander becomes the tool of the loser." - Socrates
Vita contingit, Vive cum eo. (Life Happens, Live With it.)
"Life is not measured by the number of breaths we take, but by the moments that take our breath away." -- author unknown
"De omnibus dubitandum"
