Advertisement
Guest User

Процедура rpl_install

a guest
Apr 19th, 2011
272
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.49 KB | None | 0 0
  1. CREATE OR ALTER PROCEDURE rpl_install
  2. AS
  3. DECLARE variable TABLE_NAME my_docnumber;
  4. DECLARE variable docheader my_boolean;
  5. BEGIN
  6.   FOR SELECT TABLE_NAME, is_docheader
  7.     FROM rpl_tables rt
  8.     WHERE rt.rpl_allfields = 1
  9.     INTO TABLE_NAME, docheader
  10.   do
  11.     EXECUTE PROCEDURE rpl_allfields(:TABLE_NAME, :docheader);
  12.  
  13.   FOR SELECT TABLE_NAME FROM rpl_tables rt
  14.     WHERE rt.rpl_allfields = 0
  15.     INTO TABLE_NAME
  16.   do
  17.     EXECUTE PROCEDURE rpl_somefields(:TABLE_NAME, :docheader);
  18. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement