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