Hi Euler,

This is not a bug... Firebird doesn't have this feature... You can
do this in Oracle, but not in Firebird. Well, for now you can't... Who knows
the future!!!

Greetings,
Jean Derrie Rigo
rigo@...

-----Mensagem original-----
De: firebird-tools@yahoogroups.com [mailto:firebird-tools@yahoogroups.com]
Em nome de Euler Jr.
Enviada em: quarta-feira, 25 de maio de 2005 08:45
Para: firebird-tools@yahoogroups.com
Assunto: Re: [firebird-tools] Re: GPRE

Hi Paul,

thank you for reply, but GPRE report:
Inconsistent database specifier

This is a not fixed bug?

I need insert data from db1 to db2 using this command:

EXEC SQL
INSERT INTO db2.TEST SELECT * FROM db1.TEST;

I don´t use CURSOR, FETCH, etc why it is small. The command above is more
fast.

Euler Jr.

----- Original Message -----
From: Paul Beach
To: firebird-tools@yahoogroups.com
Sent: Wednesday, May 25, 2005 8:23 AM
Subject: RE: [firebird-tools] Re: GPRE


>EXEC SQL SET DATABASE db1 = "c:\test1.fdb";
>EXEC SQL SET DATABASE db2 = "c:\test2.fdb";

OK, try

EXEC SQL SET DATABASE db1 = 'c:\\test1.fdb';
EXEC SQL SET DATABASE db2 = 'c:\\test2.fdb';

Paul



----------------------------------------------------------------------------
--
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-tools/

b.. To unsubscribe from this group, send an email to:
firebird-tools-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[Non-text portions of this message have been removed]




Yahoo! Groups Links