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

QUALITY_CROPFULLNAME_BYID

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

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

Описание

Полное имя культуры с классом и сортом по QUALITYID

Определение

CREATE PROCEDURE QUALITY_CROPFULLNAME_BYID(
    QUALITYID INTEGER,
    USEFULLNAMES SMALLINT)
RETURNS (
    CROPFULLNAME VARCHAR(100),
    CLASSID INTEGER)
AS
begin
  select
      QUALITY_CROPFULLNAME.CROPFULLNAME, QUALITY.CLASSID
    from QUALITY
      left join QUALITY_CROPFULLNAME(QUALITY.CROPID, QUALITY.CLASSID, QUALITY.SORTID, :USEFULLNAMES) on (0=0)
    where (QUALITY.QUALITYID = :QUALITYID)
  into :CROPFULLNAME, :CLASSID;

  suspend;
end