"D:\Replicator_1_beta\Client\TEMPLATE.GDB" Previous topic Chapter index Next topic

PROCESS_MASTER_INSERTS

 

 

Descriptions

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

 

Input Parameters

There are no input parameters for procedure PROCESS_MASTER_INSERTS

 

Output Parameters

There are no output parameters for procedure PROCESS_MASTER_INSERTS

 

Definition


CREATE PROCEDURE PROCESS_MASTER_INSERTS 
AS
BEGIN
  INSERT INTO MASTER
  (
    GID,
    LOG_OWN_GEN,
    /*Table specific*/
    DATA
  )
  SELECT
    LOG_GID,
    LOG_OWN_GEN,
    /*Table specific*/
    DATA
  FROM
    MASTER_INPUT
  WHERE
    LOG_ACTION = 'I' AND ( LOG_GID NOT IN ( SELECT LOG_GID FROM LOG_MASTER ) );
END

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

 

Хостинг от uCoz