API UpdateCrossNumbers

Description

Method allows You to update cross number in system.

Exact name

API_UpdateCrossNumbers

Type

Standard executable stored procedure.

Specification

Parameter	Data type	Value range	Description	Relation
@ID	int		Internal system id	API_GetCrossNumbers.ID
@GroupID	int		Group ID	API_GetProductGroups.ID
@Code	nvarchar(35)		TecDoc code or Laximo code
@BrandID	int		Brand ID	API_GetTecDocBrands.ID or API_GetLaximoBrands.ID
@BrandName	nvarchar(80)		Brand name	API_GetTecDocBrands.Name or API_GetLaximoBrands.Name
@TypeID	int		Type ID	TecDoc cross = 0; Laximo cross = 1;

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE @ID int 
 DECLARE @GroupID int
 DECLARE @Code nvarchar(35)
 DECLARE @BrandID int
 DECLARE @BrandName nvarchar(80)
 DECLARE @TypeID int

 
 SELECT @ID = [ID], 
       @GroupID = [GroupID], 
       @Code = 'GCH585',
       @BrandID = [BrandID],
       @BrandName = [BrandName],
       @TypeID = [TypeID]
 FROM   [API_GetCrossNumbers] 
 WHERE  id = 3
 
 EXECUTE @return_value = [API_UpdateCrossNumbers] 
  @ID, 
  @GroupID,
  @Code,
  @BrandID,
  @BrandName,
  @TypeID

Notices

None.