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

PROCESS_DETAIL_UPDATES

Descriptions

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

Input Parameters

There are no input parameters for procedure PROCESS_DETAIL_UPDATES

Output Parameters

There are no output parameters for procedure PROCESS_DETAIL_UPDATES

Definition

CREATE PROCEDURE PROCESS_DETAIL_UPDATES 
AS
DECLARE VARIABLE LOG_GID NUMERIC( 18, 0 );
DECLARE VARIABLE LOG_OWN_GEN INTEGER;
/*-------------Table specific------------------------*/
DECLARE VARIABLE DATA VARCHAR( 255 );
DECLARE VARIABLE MASTER_GID NUMERIC( 18, 0 );
BEGIN
  FOR
    SELECT
      LOG_GID,
      LOG_OWN_GEN,
      /*-Table specific-----*/
      DATA,
      MASTER_GID
    FROM
      DETAIL_INPUT
    WHERE LOG_ACTION IN ( 'I', 'U' )
    INTO
      :LOG_GID,
      :LOG_OWN_GEN,
      /*-Table specific-----*/
      :DATA,
      :MASTER_GID
  DO
  BEGIN
    UPDATE DETAIL
    SET/*------Table specific-------*/
      DATA = :DATA,
      MASTER_GID = :MASTER_GID
    WHERE
      GID = :LOG_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