"D:\Replicator_1_beta\Client\TEMPLATE.GDB"

PROCESS_MASTER_UPDATES

Descriptions

Вспомогательная. Обработать записи об изменениях в MASTER_INPUT

Input Parameters

There are no input parameters for procedure PROCESS_MASTER_UPDATES

Output Parameters

There are no output parameters for procedure PROCESS_MASTER_UPDATES

Definition

CREATE PROCEDURE PROCESS_MASTER_UPDATES 
AS
DECLARE VARIABLE GID NUMERIC( 18, 0 );
DECLARE VARIABLE LOG_OWN_GEN INTEGER;
/*-------------Table specific------------------------*/
DECLARE VARIABLE DATA VARCHAR( 255 );
BEGIN
  FOR
    SELECT
      LOG_GID,
      LOG_OWN_GEN,
      /*-Table specific-----*/
      DATA
    FROM
      MASTER_INPUT
    WHERE LOG_ACTION IN ( 'I', 'U' )
    INTO
      :GID,
      :LOG_OWN_GEN,
      /*-Table specific-----*/
      :DATA
  DO
  BEGIN
    UPDATE MASTER
    SET/*------Table specific-------*/
      DATA = :DATA
    WHERE
      GID = :GID AND LOG_OWN_GEN < :LOG_OWN_GEN;
  END
END

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 11/13/2006 10:51 PM