🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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
#94
Author: lex9999
Date: Thu, 13 Jul 2006 09:54
44 lines
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