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

PROCESS_DB_PROFILE_INSERTS

Descriptions

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

Input Parameters

There are no input parameters for procedure PROCESS_DB_PROFILE_INSERTS

Output Parameters

There are no output parameters for procedure PROCESS_DB_PROFILE_INSERTS

Definition

CREATE PROCEDURE PROCESS_DB_PROFILE_INSERTS 
AS
BEGIN
  INSERT INTO DB_PROFILE
  (
    DB_ID
  )
  SELECT I.LOG_DB_ID FROM DB_PROFILE_INPUT I
      WHERE
        I.LOG_ACTION = 'I' AND ( I.LOG_DB_ID NOT IN ( SELECT L.LOG_DB_ID FROM LOG_DB_PROFILE L ) );
END

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