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

Insert

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

    INSERT INTO ProductFeatures(Name,Description)VALUES('Sample Product Features','Description')

Bulk Insert

    INSERT INTO ProductFeatures#TEMP (Name,Description) VALUES('Sample Product Features 1','Sample Description')
    INSERT INTO ProductFeatures#TEMP (Name,Description) VALUES('Sample Product Features 2','Sample Description')
    INSERT INTO ProductFeatures (Name,Description) SELECT Name,Description FROM ProductFeatures#TEMP

Update

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

    UPDATE ProductFeatures SET Name = 'Sample Product Features' WHERE Id = 2

Bulk Update

    INSERT INTO ProductFeatures#TEMP (Id,Name,Description) VALUES(1,'Sample Product Features 1','Sample Description')
    INSERT INTO ProductFeatures#TEMP (Id,Name,Description) VALUES(2,'Sample Product Features 2','Sample Description')
    UPDATE ProductFeatures (Id,Name,Description) SELECT Id,Name,Description FROM ProductFeatures#TEMP

Delete

Delete is not supported for this table.

Columns

Name	Type	ReadOnly	Description
Id [KEY]	Integer	True
Name	String	False
RvDescription	String	False
Description	String	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