> > > > and you know it's been like that for a long long time. Even
> > when I used
> > > > external tables in version 4, I had this problem. I always had
> > > to place the
> > > > external file BEFORE I restored. And yes it was OK for WIN to
> > > WIN resotre
> > > > but would never have worked for WIN to Linux or versa. You need
> > > to disengage
> > > > the external table first, before backup.
> > > > Alan
> > > >
> > >
> > > Aren't there any switch to gbak to NOT process external files during
> > > restore ?
> > >
> > >
> > > Regards
> > > Boguslaw Brandys
> >
> > only to incorporate them into the backup as if they are internal tables
> > Alan
> >
> >
> > Hi
> >
> > We help ourselves by setting the field rdb$relations.rdb$external_file

to

> > blank
> >
> > Regards
> > Bogdan
>
> nice trick

Doesn't work if you only got the backup though ;-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com