Excel Add-In for BCart

Build 22.0.8503

OtherAddresses

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

Insert

To add a OtherAddresses, specify Name, CustomerId and the non-read-only columns.

    INSERT INTO OtherAddresses(Name,Zip,Pref,Address1,Address2,CustomerId)VALUES('Sample Address','123-4567','Miyagi','Sendai','CData',9999)

Bulk Insert


    INSERT INTO OtherAddresses#TEMP (Name,Zip,Pref,Address1,Address2,CustomerId) VALUES('Sample Address 1','123-4567','Miyagi','Sendai','CData',9999)
    INSERT INTO OtherAddresses#TEMP (Name,Zip,Pref,Address1,Address2,CustomerId) VALUES('Sample Address 2','123-4567','Miyagi','Sendai','CData',9999)
    INSERT INTO OtherAddresses (Name,Zip,Pref,Address1,Address2,CustomerId) SELECT Name,Zip,Pref,Address1,Address2,CustomerId FROM OtherAddresses#TEMP

Update

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

    UPDATE OtherAddresses SET Name = 'Sample Address' WHERE Id = 2

Bulk Update


    INSERT INTO OtherAddresses#TEMP (Id,Name) VALUES(1,'Sample Address 1')
    INSERT INTO OtherAddresses#TEMP (Id,Name) VALUES(2,'Sample Address 2')
    UPDATE OtherAddresses (Id,Name) SELECT Id,Name FROM OtherAddresses#TEMP

Delete

Delete is not supported for this table.

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

CustomerId Integer False

DestinationCode String False

CompName String False

Department String False

Name String False

Zip String False

Pref String False

Address1 String False

Address2 String False

Address3 String False

Tel String False

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