ADO.NET Provider for Lohaco

Build 21.0.7930

ItemImages

Retrieve information related to item images.

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. For example, the following query is processed server side:

SELECT * FROM ItemImages

SELECT * FROM ItemImages WHERE ItemCd='itemcd'
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.

Insert

To add an Item in an exsisting group ItemImages,ItemAttribute child tables are necessary. The insert is achived by using temp tables.

INSERT INTO ItemImages (itemcd,filename) values ('itemcd','img.jpg')

Update

Lohaco allows updates.

UPDATE ItemImages SET FileName='newName' WHERE  ItemCd = '1231231123' 

Delete

ItemAttributes can be deleted by providing the ItemCd .

DELETE FROM ItemImages WHERE ItemCd='1231231123'

Columns

Name Type ReadOnly References Description
SellerId String False

The Id of the seller.

ItemCd [KEY] String False

Items.ItemCd

The item code.

Path String True

Path of the file.

FileName String False

Name of the file.

SupplementHeight String True

Image Supplement (height).

SupplementThreeSizeB String True

Image supplement (three sizes B).

SupplementThreeSizeW String True

Image supplement (three sizes W).

SupplementThreeSizeH String True

Image supplement (three sizes H).

SupplementWearSize String True

Image supplement (wear size).

SupplementWeight String True

Image supplement (body weight).

SupplementOther String True

Image Supplement (Other).

FileNameNotExtension String True

File name (without the

Extension String True

Only the extension of the file name (without the '.').

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