CHECK_DB_ID_REFERENCE

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

Descriptions

Эмулирует ссылочное ограничение. Проверяет ссылку на DB_PROFILE

Input Parameters

Parameter	Type
A_DB_ID	INTEGER

Output Parameters

There are no output parameters for procedure CHECK_DB_ID_REFERENCE

Definition


CREATE PROCEDURE CHECK_DB_ID_REFERENCE (
    A_DB_ID INTEGER)
AS
DECLARE VARIABLE DB_ID_COUNT INTEGER;
BEGIN
  SELECT COUNT( DB_ID ) FROM DB_PROFILE WHERE DB_ID = :A_DB_ID INTO :DB_ID_COUNT;
  IF( DB_ID_COUNT = 0 )THEN EXCEPTION E_CHECK_DB_ID_REFERENCE;
END

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

Хостинг от uCoz