Excel Add-In for BCart

Build 22.0.8503

ProductFeatures

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

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