Fórum Ordenar Descrições #50928

CREATE PROCEDURE BUSCADETALHES (
    NTABELA VARCHAR(50))
RETURNS (
    NOME VARCHAR(50),
    DESCRICAO BLOB SUB_TYPE 0 SEGMENT SIZE 80)
AS
begin
    FOR Select RDB$FIELD_NAME, RDB$DESCRIPTION
    From  RDB$RELATION_FIELDS
    Where (UPPER(RDB$RELATION_NAME)=UPPER(:nTabela)) and
          (RDB$DESCRIPTION is not null)
    Order BY RDB$DESCRIPTION
    INTO :NOME, :DESCRICAO
    DO
      suspend;
end