""Nick Upson"" <uebridger@...> wrote in message
news:F127zmRf6Ci6nx8dyDd0001ea74@......

>
> >Anyway, your issue seems to be that the external table is still an

external

> >table after the restore, so it should be read again from the ASCII file.

If

> >this is the case, can you query the system tables to know if the
> >information
> >about fields and lengths is correct? I found some fields for external
> >tables
> >definitions in the system tables that contrary to my expectation, aren't
> >used.
>
> I don't know what to extract

select * from rdb$relations where rdb$relation_name = 'TBL';

select * from rdb$relation_fields rf join rdb$fields f
on rf.rdb$field_source = f.rdb$field_name
where rf.rdb$relation_name = 'TBL'
order by rf.rdb$field_name;

> >Maybe it's a bug in v4's gbak?
>
> but has it been fixed in a later version?

I don't know. I never saw it documented or acknowledged, sorry.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing