Advertisement
econz

Firebird - Multiplas Conexões

Feb 7th, 2012
232
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.61 KB | None | 0 0
  1. EXECUTE BLOCK RETURNS (
  2. TEXTO VARCHAR(100)
  3. )
  4. AS
  5. BEGIN
  6.  
  7.       EXECUTE STATEMENT 'Select Nome from Empresa'
  8.       ON EXTERNAL DATA SOURCE 'C:\Bancos\base1\base1.FDB' AS USER 'sysdba' PASSWORD 'masterkey'
  9.       INTO :TEXTO;
  10.       SUSPEND;
  11.  
  12.       EXECUTE STATEMENT 'Select Nome from Empresa'
  13.       ON EXTERNAL DATA SOURCE 'C:\Bancos\base2\base2.FDB' AS USER 'sysdba' PASSWORD 'masterkey'
  14.       INTO :TEXTO;
  15.       SUSPEND;
  16.  
  17.       EXECUTE STATEMENT 'Select Nome from Empresa'
  18.       ON EXTERNAL DATA SOURCE 'C:\Bancos\base3\base3.FDB' AS USER 'sysdba' PASSWORD 'masterkey'
  19.       INTO :TEXTO;
  20.       SUSPEND;
  21.  
  22. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement