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

PROCESS_DETAIL_INSERTS

Descriptions

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

Input Parameters

There are no input parameters for procedure PROCESS_DETAIL_INSERTS

Output Parameters

There are no output parameters for procedure PROCESS_DETAIL_INSERTS

Definition

CREATE PROCEDURE PROCESS_DETAIL_INSERTS 
AS
BEGIN
  INSERT INTO DETAIL
  (
    GID,
    LOG_OWN_GEN,
    /*Table specific*/
    DATA,
    MASTER_GID
  )
  SELECT
    LOG_GID,
    LOG_OWN_GEN,
    /*Table specific*/
    DATA,
    MASTER_GID
  FROM
    DETAIL_INPUT
  WHERE
    LOG_ACTION = 'I' AND (LOG_GID NOT IN (SELECT LOG_GID FROM LOG_DETAIL));
END

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