Hello, there's among the messages one whose text is "Cannot include the same field (@1.@2) twice in the ORDER BY clause with conflicting sorting options"
AFAIK, it's not used and I can do: select f from t order by f asc, f desc; I don't remember if there's some reason to allow that. C. --- Claudio Valderrama C. Consultant, SW developer. ------------------------------------------------------------------------------ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel