Hi Sascha

As far as I remember you can put 'select * from table' into both source and
destination SQL and it will work it out for you.

Give it a try

Regards
Paul

> -----Original Message-----
> From: IBObjects@yahoogroups.com
> [mailto:IBObjects@yahoogroups.com] On Behalf Of saschaschilberz
> Sent: 27 November 2008 11:00
> To: IBObjects@yahoogroups.com
> Subject: Re: [IBO] Datapump Question: What do i wrong?
>
> Hi Helen,
>
> but please look at this post:
>
> http://tech.groups.yahoo.com/group/IBObjects/messages/40442?th
> readed=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
> >
>
>
>
> ------------------------------------
>
> ______________________________________________________________
> _____________
> IB Objects - direct, complete, custom connectivity to
> Firebird or InterBase
> without the need for BDE, ODBC or any other layer.
> ______________________________________________________________
> _____________
> http://www.ibobjects.com - your IBO community resource for
> Tech Info papers,
> keyword-searchable FAQ, community code contributions and more
> ! Yahoo! Groups Links
>
>
>