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