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