"localhost:/firebird/data/ILICHEVSK2.FDB". Процедуры

OPERATIONS_OPERATIONNAME

Входные параметры

Выходные параметры

Описание

(Нет описания для процедуры OPERATIONS_OPERATIONNAME)

Определение

CREATE PROCEDURE OPERATIONS_OPERATIONNAME(
    OPERATIONID INTEGER,
    OPERATIONPARAM INTEGER)
RETURNS (
    OPERATIONNAME VARCHAR(100),
    CLASSID INTEGER)
AS
declare variable CROPID integer;
declare variable SORTID integer;
declare variable STR varchar(100);
begin
  select OPERATION.OPERATIONNAME
    from OPERATION
    where (OPERATION.OPERATIONID = :OPERATIONID)
  into OPERATIONNAME;
  if (:OPERATIONID = 22) then
    select
        QUALITY_CROPFULLNAME_BYID.CROPFULLNAME, QUALITY_CROPFULLNAME_BYID.CLASSID
      from QUALITY_CROPFULLNAME_BYID(:OPERATIONPARAM, 1)
    into :STR, :CLASSID;
    OPERATIONNAME = :OPERATIONNAME || coalesce(': ' || STR, '');
  suspend;
end