CREATE TABLE LUACCOM (
LUID INTEGER NOT NULL,
SUPPID INTEGER,
BROKERID INTEGER,
ARRDATE DATE,
ENDDATE DATE,
BUILDID INTEGER,
BUILDINGNAME CHAR(35),
RESORT INTEGER,
RESORTNAME CHAR(35),
RATING CHAR(5),
ROOMTYPECODE CHAR(10),
BOARDTYPECODE CHAR(10),
CONTRACTTYPE CHAR(10),
UPDATED DATE,
MAXOCC CHAR(100),
MINOCC CHAR(100),
REQUESTIFFULL CHAR(1),
FIXMARGINS CHAR(1),
CONTRACTORID INTEGER,
CODING CHAR(36) [1:750,1:30],
NOROOMS INTEGER,
ANYINCTRANS CHAR(1),
PRICES DOUBLE PRECISION [1:750,1:210],
BROCHUREPRICING CHAR(1),
BOARDTYPESET CHAR(20),
REQUESTINSIDERELEASE CHAR(1)
);
ALTER TABLE LUACCOM ADD PRIMARY KEY (LUID);
Here is the text of the error message:
"ErrorNo: 32 - subscript out of bounds"
After removing fields CODING and PRICES from replication schema
replication works fine, but these fields are required.
Also table replicates if both fields contains NULL.
I think trouble is in array fields, but IBReplicator supports them.