JDBC Driver for BCart

Build 22.0.8503

OrderProducts

Returns data from OrderProducts table.

Select

The 本製品 will use the BCart API to process WHERE clause conditions built with the following columns and operators. The rest of the filter is executed client side within the 本製品.

  • Most of the columns support the following operators: <, >, <=, >=, =, !=, IN, NOT_IN.
  • Custom field columns support the following operator: =.
  • Options column does not support server side operators.
For example, the following query is processed server side:
    SELECT * FROM OrderProducts WHERE ProductName = 'Sample Order Product'
    SELECT * FROM OrderProducts WHERE OrderId IN (1,10)
    SELECT * FROM OrderProducts WHERE ShippingSize <= 10

Insert

Insert is not supported for this table.

Update

BCart allows updates for ProductName, MainNo and the non-read-only columns.

    UPDATE OrderProducts SET ProductName = 'Sample Order Product' WHERE Id = 2

Bulk Update


    INSERT INTO OrderProducts#TEMP (Id,ProductName,MainNo) VALUES(1,'Sample Order Product 1','1')
    INSERT INTO OrderProducts#TEMP (Id,ProductName,MainNo) VALUES(2,'Sample Order Product 2','2')
    UPDATE OrderProducts (Id,ProductName,MainNo) SELECT Id,ProductName,MainNo FROM OrderProducts#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

OrderId Integer False

LogisticsId Integer False

ProductId Integer False

MainNo String False

ProductNo String False

JanCode String False

LocationNo String False

ProductName String False

ProductSetId Integer False

SetName String False

UnitPrice Decimal True

SetQuantity Integer True

SetUnit String False

OrderProCount Integer True

ShippingSize Integer False

TaxRate String True

TaxTypeId Integer True

TaxIncl Integer True

ItemType String True

Options String True

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8503