[firebase-br] Acesso Remoto

[Carlos H. Cantu (TeamFB)]

Tente o select abaixo:

select f.rdb$field_name,
f.rdb$field_source,
f.rdb$null_flag,
f.rdb$default_source,
fs.rdb$null_flag,
fs.rdb$field_name,
fs.rdb$field_type,
fs.rdb$field_length,
fs.rdb$field_scale,
fs.rdb$field_sub_type,
fs.rdb$segment_length,
fs.rdb$dimensions,
d.rdb$dimension,
d.rdb$lower_bound,
d.rdb$upper_bound,
fs.rdb$character_set_id,
f.rdb$collation_id,
cr.rdb$character_set_name,
co.rdb$collation_name,
f.rdb$field_position,
fs.rdb$computed_source,
fs.rdb$character_length,
fs.rdb$default_source,
f.rdb$description,
fs.rdb$collation_id
,fs.rdb$field_precision
from rdb$relation_fields f
left join rdb$fields fs on fs.rdb$field_name = f.rdb$field_source
left join rdb$field_dimensions d on d.rdb$field_name = fs.rdb$field_name
left join rdb$character_sets cr on fs.rdb$character_set_id = cr.rdb$character_set_id
left join rdb$collations co on ((f.rdb$collation_id = co.rdb$collation_id) and
(fs.rdb$character_set_id = co.rdb$character_set_id))
where f.rdb$relation_name = 'NOME_DA_TABELA'
order by f.rdb$field_position, d.rdb$dimension

[]s
Cantu (Membro do TeamFB - FireBase)
http://www.warmboot.com.br
FireBase - http://www.FireBase.com.br

SK> Cantu   boa tarde

SK> Copiei do seu livro Firebird Essencial a rotina abaixo para listar todos os
SK> campos de uma tabela

SK> SELECT R.RDB$FIELD_NAME AS CAMPO
SK> , T.RDB$TYPE_NAME AS TIPO
SK> , F.RDB$FIELD_LENGTH AS TAMANHO
SK> , R.RDB$NULL_FLAG
SK> , F.RDB$VALIDATION_SOURCE
SK> , RDB$FIELD_TYPE
SK>  FROM RDB$RELATION_FIELDS R
SK>  JOIN RDB$FIELDS F  ON F.RDB$FIELD_NAME = R.RDB$FIELD_SOURCE
SK>  JOIN RDB$TYPES T  ON F.RDB$FIELD_TYPE = T.RDB$TYPE
SK>  WHERE (R.RDB$RELATION_NAME = 'SKLLPDS')
SK> AND (T.RDB$FIELD_NAME = 'RDB$FIELD_TYPE')
SK> ORDER BY R.RDB$FIELD_NAME

SK> Acontece que esta rotina não lista os campos NUMÉRICOS
SK> Não sei como corrigir esta rotina e preciso que liste TODOS os campos.
SK> O que fiz de errado ?

SK> Grato

SK> Sergio Keller


SK> ______________________________________________
SK> FireBase-BR (www.firebase.com.br) - Hospedado em www.locador.com.br
SK> Para editar sua configuração na lista, use o endereço
SK> http://mail.firebase.com.br/mailman/listinfo/lista_firebase.com.br
SK> Para consultar mensagens antigas: http://firebase.com.br/pesquisa