"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