Erro no firebird 2.0

Question

ol� pessoal...ta dando esse no banco firebird 2.0:Column unknown.RDB$RELATION_FIELDS.RDB$SYSTEM_FLAGo erro acontece quando tento dar esse select:select (rdb$relation_name) as Tabela,(r.rdb$field_name)...

Emerson Nascimento · Answer

se voc� est� utilizando aliases, voc� precisa indic�-lo ao fazer refer�ncia ao campo. no seu caso, ao ser referir � tabela rdb$relation_fields, dever� ser uitilizado [b:bf3882ff16]r[/b:bf3882ff16]:

select
  (f.rdb$relation_name) as Tabela,
  (r.rdb$field_name) as Campo,
  (t.rdb$type_name) as Tipo,
  (f.rdb$field_length) as tamanho,
  r.rdb$null_flag,
  f.rdb$validation_source
from
  rdb$relation_fields r, rdb$types t, rdb$fields f
where
  f.rdb$field_name=r.rdb$field_source and
  t.rdb$field_name=�RDB$FIELD_TYPE� and
  f.rdb$field_type=t.rdb$type and
  r.rdb$system_flag = 0 and
  r.rdb$relation_name=:Tabela
order by
  r.rdb$relation_name,f.rdb$field_name

L3gion4rio · Answer

hum.... vou ver isso aqui...valeu emerson...

F�rum Erro no firebird 2.0 #58337