martins.goncalo wrote:

>
> Yes, that works. But if I put the
> ( select name from city order by population ) city
>
> in a procedure (ex: sp_get_citys_by_population)
> the list doesn't work. The order is incorrect. Is this a bug of
> firebird or list just doesn't work with procedures?

It would be helpful to show us the exact query and procedure you use.


Dmitry