econz icon

Firebird - Multiplas Conexões 2 ( IBExpert )

econz | PRO | 02/07/12 06:38:07 PM UTC | 0 ⭐ | 805 👁️ | Never ⏰ | []
SQL |

730 B

|

None

|

0 👍

/

0 👎

EXECUTE IBEBLOCK RETURNS (
TEXTO VARCHAR(100)
)
AS
BEGIN
 
   CON1 = ibec_CreateConnection(__ctFirebird,
      'DBName="C:\bancos\base\banco1.fdb";
      Clientlib=GDS32.dll;User=SYSDBA;
      Password=masterkey;
      Names=NONE;
      SQLDialect=3;');
 
   ibec_UseConnection(CON1);
   --ou USE CON1;
   SELECT Nome FROM Empresa INTO :TEXTO;
   SUSPEND;
   CLOSE CONNECTION CON1;
 
 
 
 
   CON2 = ibec_CreateConnection(__ctFirebird,
      'DBName="C:\bancos\base2\banco2.fdb";
      Clientlib=GDS32.dll;User=SYSDBA;
      Password=masterkey;
      Names=NONE;
      SQLDialect=3;');
 
   ibec_UseConnection(CON2);
   --ou USE CON2;
   SELECT Nome FROM Empresa INTO :TEXTO;
   SUSPEND;
   CLOSE CONNECTION CON2;
 
END

Comments