> saschaschilberz wrote:
> > ...
> > 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
> > ...
>
> Maybe you need the qli utility (in Firebird's "bin"
> folder). Documentation is scarce ...

* The short version. In QLI:

ready src.fdb as src;
ready dest.fdb as dest;
dest.table1 = src.table1;

* Or the long version:
http://www.ibphoenix.com/downloads/qli_syntax.pdf

* Or this one here has QLI examples as well:
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_db_corr


;-)

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/