Hi All,
This simple embedded sql code, writted in C language, when
pre-processed with GPRE, display message:

inconsistent database especifier

Exemple:

/*
db1 and db2 have some tables and structures
db1 is populated and db2 is empty
*/

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

EXEC SQL CONNECT ALL;
EXEC SQL SET TRANSACTION;

/* TEST is a table from db1 and db2 */
/* ERROR HERE !! */
EXEC SQL INSERT INTO db2.TEST SELECT * FROM db1.TEST;

EXEC SQL COMMIT;
EXEC SQL DISCONNECT ALL;


The command line is:
gpre test.e -c -manual -no_lines -either_case -user sysdba
-password masterkey


Thank´s
Euler Jr