Excel Add-In for BCart

Build 22.0.8503

Categories

Returns data from Categories 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 Categories WHERE Name = 'Sample Category'
    SELECT * FROM Categories WHERE Id IN (1,10)
    SELECT * FROM Categories WHERE Priority <= 5

Insert

To add a Categories, specify Name and the non-read-only columns.

    INSERT INTO Categories(Name)VALUES('Sample Category')

Bulk Insert


    INSERT INTO Categories#TEMP (Name) VALUES('Sample Category 1')
    INSERT INTO Categories#TEMP (Name) VALUES('Sample Category 2')
    INSERT INTO Categories (Name) SELECT Name FROM Categories#TEMP

Update

BCart allows updates for Name, Description and the non-read-only columns.

    UPDATE Categories SET Name = 'Sample Category' WHERE Id = 2

Bulk Update


    INSERT INTO Categories#TEMP (Id,Name) VALUES(1,'Sample Category 1')
    INSERT INTO Categories#TEMP (Id,Name) VALUES(2,'Sample Category 2')
    UPDATE Categories (Id,Name) SELECT Id,Name FROM Categories#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Name String False

Description String False

RvDescription String False

ParentCategoryId Integer False

HeaderImage String False

BannerImage String False

MenuImage String False

MetaTitle String False

MetaKeywords String False

MetaDescription String False

Priority Integer False

Flag Integer False

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