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

PROCESS_DB_PROFILE_DELETES

Descriptions

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

Input Parameters

There are no input parameters for procedure PROCESS_DB_PROFILE_DELETES

Output Parameters

There are no output parameters for procedure PROCESS_DB_PROFILE_DELETES

Definition

CREATE PROCEDURE PROCESS_DB_PROFILE_DELETES 
AS
BEGIN
  DELETE
    FROM  DB_PROFILE
    WHERE DB_ID IN ( SELECT LOG_DB_ID FROM DB_PROFILE_INPUT WHERE LOG_ACTION = 'D' );
  /**/
  DELETE
    FROM  CLIENT
    WHERE DB_ID IN ( SELECT LOG_DB_ID FROM DB_PROFILE_INPUT WHERE LOG_ACTION = 'D' );
END

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