Excel Add-In for BCart

Build 22.0.8503

ProductStock

Returns data from ProductStock 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.
For example, the following query is processed server side:
    SELECT * FROM ProductStock WHERE Name = 'Sample Stock'
    SELECT * FROM ProductStock WHERE Id IN (1,10)
    SELECT * FROM ProductStock WHERE Stock <= 10

Insert

Insert is not supported for this table.

Update

BCart allows updates for Stock, StockFlag and the non-read-only columns.

    UPDATE ProductStock SET Stock = 15 WHERE ProductNo = 2

If need update the number of stocks by relative value, Specify relative value by StockRelativeUpdateValue.

The following query reduces the number of stocks by two.

    UPDATE ProductStock SET StockRelativeUpdateValue = -1 WHERE ProductNo = 2

Bulk Update


    INSERT INTO ProductStock#TEMP (ProductNo,Stock) VALUES('A001',2)
    INSERT INTO ProductStock#TEMP (ProductNo,Stock) VALUES('A002',3)
    UPDATE ProductStock (ProductNo,Stock) SELECT ProductNo,Stock FROM ProductStock#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id Integer True

ProductId Integer True

ProductNo [KEY] String True

Name String True

Stock Integer False

StockFlag Integer False

StockParent String False

Pseudo-Columns

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。

Name Type Description
StockRelativeUpdateValue String

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