It was yesterday a thread very similar (order by month from datetime). Sounds interesting. I'll check it.
Vlad
>>Can you be more specific? What do you mean by "corrupted result"?
>
>I am able to simulate that all the time.
>
>I have a table which contains a datetime field. In my SQL, I would like to order by that field. So, it goes like this.
>
>SELECT NOM,SIZE,NOTES,CREATION FROM FTP ORDER BY CREATION
>
>This is giving me a corrupted result where some records are duplicated. Also, when scrolling down the result, when reaching the point of corruption, I can't go any further.
>
>If I take any other tag instead, it works. I did that on another test table I did and it is always the same.
Previous
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