JDBC Driver for BCart

Build 22.0.8503

OrderStatuses

Returns data from OrderStatuses 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 OrderStatuses WHERE Label = 'Sample Product'
    SELECT * FROM OrderStatuses WHERE Id IN (1,10)
    SELECT * FROM OrderStatuses WHERE SystemDefined <= 5

Insert

To add a OrderStatuses, specify Label column.

    INSERT INTO OrderStatuses(Label)VALUES('Sample Label')

Bulk Insert


    INSERT INTO OrderStatuses#TEMP (Label) VALUES('Sample Label 1')
    INSERT INTO OrderStatuses#TEMP (Label) VALUES('Sample Label 2')
    INSERT INTO OrderStatuses (Label) SELECT Label FROM OrderStatuses#TEMP

Update

BCart allows updates for Label column.

    UPDATE OrderStatuses SET Label = 'Sample Label' WHERE Id = 2

Bulk Update


    INSERT INTO OrderStatuses#TEMP (Id,Label) VALUES(1,'Sample Label 1')
    INSERT INTO OrderStatuses#TEMP (Id,Label) VALUES(2,'Sample Label 2')
    UPDATE OrderStatuses (Id,Label) SELECT Id,Label FROM OrderStatuses#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] String True

Label String False

SystemDefined Integer True

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