ADO.NET Provider for Lohaco

Build 21.0.7930

Inventory

Search and update inventory information.

Select

The {i will use the Lohaco API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the {i.

  • Id, Name and Description support the following operators: =, IN, and NOT IN.
For example, the following query is processed server side:
SELECT * FROM Inventory

SELECT * FROM Inventory WHERE ItemCd = 'item code'

SELECT * FROM Inventory WHERE CatalogItemCd = 'catalog item code'
You can turn off client-side execution by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.

Update

Lohaco allows updates. Groupcd should be spefied

UPDATE Inventory  SET Quantity = 12 Where ItemCd = 'item code'

Batch Update

Insert INTO Inventory#Temp (Quantity, ItemCd) Values (2, '132131231565848898')

Insert INTO Inventory#Temp (Quantity, ItemCd) Values (4, '12345678998752365')

Insert INTO Inventory#Temp (Quantity, ItemCd) Values (1, '123456789987523565665')

Insert INTO Inventory#Temp (Quantity, CatalogItemCd) Values (2, 'L06368493')

Insert INTO Inventory#Temp (Quantity, CatalogItemCd) Values (4, 'L06368510')

Update Inventory ( Quantity, ItemCode) Select  Quantity, ItemCd from Inventory#Temp")

Columns

Name Type ReadOnly References Description
SellerId String True

The Id of the seller.

ItemCd [KEY] String False

The product code.

CatalogItemCd String False

The catalog code.

Quantity Integer False

The stock quantity.

GroupCd String True

The product group code.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 21.0.7930