Procedura-UpdateGeneralLedger3

Parametry:

Název	Popis	Datový typ
IN_ID		Char(10)
IN_CustGroup		VarChar(60)

Tělo:

BEGIN
  select ID from GeneralLedger3 where ID = :IN_ID into mID;
  if (mID is Null) then
    insert into GeneralLedger3 (ID, CustGroup) VALUES (:IN_ID, :IN_CustGroup);
  else
    update GeneralLedger3 set CustGroup = :IN_CustGroup where ID = :IN_ID; 
END;

Generated by ABRA Software a.s. 27.10.2021 16:34:18