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

CHANGES_COUNT

Descriptions

Возвращает кол-во изменений (кол-во записей с поколением NULL)

Input Parameters

There are no input parameters for procedure CHANGES_COUNT

Output Parameters

Definition

CREATE PROCEDURE CHANGES_COUNT 
RETURNS (
    CHANGES_COUNT NUMERIC (18, 0))
AS
DECLARE VARIABLE TMP NUMERIC( 18, 0);
BEGIN
  CHANGES_COUNT = 0;
  /*Если LOG_INS_GEN IS NULL, зна÷ит и LOG_UPD_GEN IS NULL*/
  SELECT COUNT(*) FROM LOG_DB_PROFILE WHERE LOG_UPD_GEN IS NULL INTO :TMP;
  CHANGES_COUNT = CHANGES_COUNT + TMP;
  /*==Scema specific=================================================*/
  SELECT COUNT(*) FROM LOG_MASTER WHERE LOG_UPD_GEN IS NULL INTO :TMP;
  CHANGES_COUNT = CHANGES_COUNT + TMP;
  SELECT COUNT(*) FROM LOG_DETAIL WHERE LOG_UPD_GEN IS NULL INTO :TMP;
  CHANGES_COUNT = CHANGES_COUNT + TMP;
  /*==\Scema specific=================================================*/
  SUSPEND;
END

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