This seems to be an obscure problem in some databases and I have not been
able to solve it either, although in the past there have been some good
suggestions on this list and from RBTI support. I (and a few others it
seems) have a similar but rare problem that makes no sense whatsoever. If
you eliminate the report altogether, and just perform a SELECT clause
sorting on that data, you will be able to determine if the problem is in
your report set-up, or a bug in the program (or more likely the data). If
the sort problem remains in the select, then your only real option is maybe
to dump the data to an ascii file, then delete all rows, then use load or
gateway to load the table. RELOAD command does not seem to work. PACK does
not work. What I had to do in one instance, is dump data to an archive
file (I didn't need all the data to remain in the table) and just use more
current data - this was a table that was dependent on dates so I could
archive old data. With more recent data, the sort worked correctly. never
could find the offending data piece that caused the problem, but there
obviously was one. If there is an archive of this list out there to be
posted soon (maybe), look up "weird sort problem" as the title.
Good luck
Bob C.
Message text written by INTERNET:[EMAIL PROTECTED]
>>I'm having trouble to get a report to sort correctly. I have it sort by
>TmpPSX (text 1), then by SkillLevel (integer), .....
>
>Most of the skills sort correctly except for two skills seem to not obey
the
>sort clause.
>
>Any ideas?<
