JDBC Driver for BCart

Build 22.0.8503

Points

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

Insert

To add a Points, specify CustomerId, Point, Status and the non-read-only columns.

    INSERT INTO Points(CustomerId,Point,Status)VALUES(12345,10,'Sample Status')

Bulk Insert


    INSERT INTO Points#TEMP (CustomerId,Point,Status) VALUES(12345,10,'Sample Status')
    INSERT INTO Points#TEMP (CustomerId,Point,Status) VALUES(12346,10,'Sample Status')
    INSERT INTO Points (CustomerId,Point,Status) SELECT CustomerId,Point,Status FROM Points#TEMP

Update

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

    UPDATE Points SET Point = 10 WHERE Id = 2

Bulk Update


    INSERT INTO Points#TEMP (Id,Point) VALUES(1,10)
    INSERT INTO Points#TEMP (Id,Point) VALUES(2,20)
    UPDATE Points (Id,Point) SELECT Id,Point FROM Points#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

CustomerId Integer False

OrderId Integer False

SubjectId Integer False

Point Integer False

Status String False

ActivatedAt Datetime False

CreatedAt Datetime False

UpdatedAt Datetime False

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