Advertisement
econz

Firebird - Multiplas Conexões 2 ( IBExpert )

Feb 7th, 2012
354
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.73 KB | None | 0 0
  1. EXECUTE IBEBLOCK RETURNS (
  2. TEXTO VARCHAR(100)
  3. )
  4. AS
  5. BEGIN
  6.  
  7.    CON1 = ibec_CreateConnection(__ctFirebird,
  8.       'DBName="C:\bancos\base\banco1.fdb";
  9.      Clientlib=GDS32.dll;User=SYSDBA;
  10.      Password=masterkey;
  11.      Names=NONE;
  12.      SQLDialect=3;');
  13.  
  14.    ibec_UseConnection(CON1);
  15.    --ou USE CON1;
  16.    SELECT Nome FROM Empresa INTO :TEXTO;
  17.    SUSPEND;
  18.    CLOSE CONNECTION CON1;
  19.  
  20.  
  21.  
  22.  
  23.    CON2 = ibec_CreateConnection(__ctFirebird,
  24.       'DBName="C:\bancos\base2\banco2.fdb";
  25.      Clientlib=GDS32.dll;User=SYSDBA;
  26.      Password=masterkey;
  27.      Names=NONE;
  28.      SQLDialect=3;');
  29.  
  30.    ibec_UseConnection(CON2);
  31.    --ou USE CON2;
  32.    SELECT Nome FROM Empresa INTO :TEXTO;
  33.    SUSPEND;
  34.    CLOSE CONNECTION CON2;
  35.  
  36. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement