Excel Add-In for BCart

Build 22.0.8503

Bookmarks

Returns data from Bookmarks 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 Bookmarks WHERE Id = 12345
    SELECT * FROM Bookmarks WHERE CustomerId IN (1,10)
    SELECT * FROM Bookmarks WHERE UpdatedAt <= '2019-09-26 09:20:45'

Insert

To add a Bookmarks, specify CustomerId, ProductId and the non-read-only columns.

    INSERT INTO Bookmarks(CustomerId,ProductId)VALUES(12345,12345)

Bulk Insert


    INSERT INTO Bookmarks#TEMP(CustomerId,ProductId)VALUES(12345,12345)
    INSERT INTO Bookmarks#TEMP(CustomerId,ProductId)VALUES(12345,12345)
    INSERT INTO Bookmarks (CustomerId,ProductId) SELECT CustomerId,ProductId FROM Bookmarks#TEMP

Update

BCart allows updates for CustomerId, ProductId and the non-read-only columns.

    UPDATE Bookmarks SET CustomerId = 12345 WHERE Id = 12345

Bulk Update


    INSERT INTO Bookmarks#TEMP(Id,CustomerId,ProductId)VALUES(1,12345,12345)
    INSERT INTO Bookmarks#TEMP(Id,CustomerId,ProductId)VALUES(2,12345,12345)
    UPDATE Bookmarks (Id,CustomerId,ProductId) SELECT Id,CustomerId,ProductId FROM Bookmarks#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

CustomerId Integer False

ProductId Integer False

UpdatedAt Datetime False

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