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

FORWARDER_REBILLUPDATE

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

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

Описание

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

Определение

CREATE PROCEDURE FORWARDER_REBILLUPDATE(
    NET INTEGER,
    EXPORTACTID INTEGER,
    EXPORTACTIDTO INTEGER)
RETURNS (
    FROMIT INTEGER,
    TOIT INTEGER)
AS
Begin
  update ExportActItems
    set
      ExportActItems.Weight = :Net*-1
    where ExportActItems.InventoryID = :FromIT
      and ExportActItems.ExportactID = :ExportactID;

  update ExportActItems
    set
      ExportActItems.Weight = :Net
    where
      ExportActItems.InventoryID = :ToIT and
      ExportActItems.ExportactID = :ExportActIDTo;
End