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]