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

Excel Add-In for BCart