Hi Helen,

but please look at this post:

http://tech.groups.yahoo.com/group/IBObjects/messages/40442?threaded=1&m=e&var=1&tidx=1

if i have understood it right, it ist possible.

Thanks a lot

Sascha

--- In IBObjects@yahoogroups.com, Helen Borrie <helebor@...> wrote:
>
> At 09:30 PM 27/11/2008, you wrote:
> >Hi Helen,
> >
> >thanks for your answer.
> >
> >The way with
> >insert into tab1 (
> > Col1, Col2, etc (all the same columns)
> > values (:Col1, :Col2, :etc.....)
> >works by me.
> >That wasn't my prob.
> >
> >But what i want is like
> >insert into tab1
> >select * from tab
> >
> >because i have about 100 tables wich have to be pumped.
> >So i can do it easy in a loop without specifieing the fields.
> >
> >Is it possible like that?
>
> No. If you could write cross-database queries then you wouldn't
need a datapump! Firebird doesn't support it yet.
>
> H
>