Thread View: borland.public.interbase.replication
1 messages
1 total messages
Started by lex9999
Thu, 13 Jul 2006 09:54
Trouble with array fields replication
Author: lex9999
Date: Thu, 13 Jul 2006 09:54
Date: Thu, 13 Jul 2006 09:54
44 lines
2625 bytes
2625 bytes
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.
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads