Hi,

> If it's the same structure, you just need to do exactly as you propose..
> insert into tableA (select * from tableB)

This doesn't work with different databases.

You cannot do this from a stored procedure or trigger.

The only way to do this is on the client side (application side) or via the
command line tool QLI.


With regards,

Martijn Tonies
InterBase Workbench - the developer tool for InterBase
http://www.upscene.com

Firebird Workbench - the developer tool for Firebird
http://www.upscene.com

Upscene Productions
http://www.upscene.com

"This is an object-oriented system.
If we change anything, the users object."

>
> > Hi,
> >
> >
> >
> > I need to do this action:
> >
> > Select from one_database.table into another_database.table
> >
> >
> >
> > Is it possible to do this with stored procedure?
> >
> >
> >
> > If no then is it possible to do wit IBX components? If yes then
> > what is the
> > best way to do that?