Erro no firebird 2.0

Firebird

18/05/2007

olá pessoal...ta dando esse no banco firebird 2.0:

Column unknown.
RDB$RELATION_FIELDS.RDB$SYSTEM_FLAG

o erro acontece quando tento dar esse select:

select (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
rdb$relation_fields.rdb$system_flag = 0 and
rdb$relation_name=:Tabela

order by rdb$relation_name,rdb$field_name


L3gion4rio

L3gion4rio

Curtidas 0

Respostas

Emerson Nascimento

Emerson Nascimento

18/05/2007

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



GOSTEI 0
L3gion4rio

L3gion4rio

18/05/2007

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


GOSTEI 0
POSTAR