API UpdateProduct

Z Podpora.nextis.cz
Přejít na: navigace, hledání

Description

Method allows You to update product in system.

Exact name

API_UpdateProduct

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ID3 int Internal system id API_GetProducts.ID
@SupplierID int Supplier ID API_GetCustomers.ID
@GroupID int Group ID API_GetProductGroups.ID
@SupplierProductCode nvarchar(40) Supplier product code
@ManufacturerSupplier nvarchar(50) Manufacturer supplier
@Prefix nvarchar(3) Prefix
@SupplierItemName nvarchar(150) Supplier item name
@MinimumOrderableQuantity decimal(18,2) Minimum orderable quantity
@ForeignPrice decimal(19,6) Foreign price
@BasicPrice decimal(18,6) Basic price

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE @ID3 int
 DECLARE @SupplierID int
 DECLARE @GroupID int
 DECLARE @SupplierProductCode nvarchar(40)
 DECLARE @ManufacturerSupplier nvarchar(50)
 DECLARE @Prefix nvarchar(3)
 DECLARE @SupplierItemName nvarchar(150)
 DECLARE @MinimumOrderableQuantity decimal(18,2)
 DECLARE @ForeignPrice decimal(19,6)
 DECLARE @BasicPrice decimal(19,6)

 
 SELECT @ID3 = [ID],
       @SupplierID = [SupplierID],
       @GroupID = [GroupID],
       @SupplierProductCode = [SupplierProductCode],
       @ManufacturerSupplier = [ManufacturerSupplier],
       @Prefix = [Prefix],
       @SupplierItemName = [SupplierItemName],
       @MinimumOrderableQuantity = [MinimumOrderableQuantity],
       @ForeignPrice = [ForeignPrice],
       @BasicPrice = 200
 FROM   [API_GetProducts] 
 WHERE  id = 3
 
 EXECUTE @return_value = [API_UpdateProduct] 
  @ID3,
  @SupplierID,
  @GroupID,
  @SupplierProductCode,
  @ManufacturerSupplier,
  @Prefix,
  @SupplierItemName,
  @MinimumOrderableQuantity,
  @ForeignPrice,
  @BasicPrice

Notices

None.