Please correct me if the below is wrongly found but right information. Thanks

SELECT r.RDB$FIELD_POSITION, r.RDB$FIELD_NAME
FROM RDB$RELATION_FIELDS r
WHERE rdb$relation_name = 'TSALEINVOICE'
ORDER BY rdb$field_position

--- In firebird-support@yahoogroups.com, Venus Software Operations <venussoftop@...> wrote:
>
> Hi all
>
> I would like to find out for a given tablename the field order number
> (as displayed in say FlameRobin).
>
> Please advise
>
> Thanks and regards
> Bhavbhuti
>