Subject Re: [firebird-support] Converting from IB 7.5 dialect 1 to FB 2dialect1
Author Ann W. Harrison
Svein Erling Tysvaer wrote:
> Sorry Thomas, to me this sounds like an ambiguous request, and Firebird
> is pretty strict about rejecting possible ambiguity.
> The solution in Firebird is to remove the ambiguity, e.g. you could add
> asco.app_status_order to the select and order by clause (using IBO you
> could then hide this field from the user, and I suspect that is possible
> if you don't use IBO as well). Mind you, if your data should happen to
> be ambiguous, then you'll end up with what appears as duplicates to the
> user.

Another option is to use an aggregate of the field you want to order
by. Add max(asco.app_status_order) to the select list and reference
it as "order by 3 asc" .