Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Trouble with array fields replication

4 views
Skip to first unread message

lex...@mail.ru

unread,
Jul 13, 2006, 5:54:43 AM7/13/06
to
I use IBReplicator 2.1.8 (EVAL license) and Firebird 1.5.3 under
Windows XP SP2.
I've got error message trying to replicate inserts/updates made to
following table:

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.

0 new messages