Article View: borland.public.interbase.replication
Article #94Trouble with array fields replication
From: 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.
Technical Details
Message-ID:
<1152784483.060949.195380@s13g2000cwa.googlegroups.com>Path:
arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!s13g2000cwa.googlegroups.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: f89d7,a9d5c5c74163a5ef,start X-Google-Attributes: gidf89d7,public X-Google-Language: ENGLISH,ASCII-7-bit Path: arc1-ca.pugleaf.net!g2news2.google.com!postnews.google.com!s13g2000cwa.googlegroups.com!not-for-mail From: lex9999@mail.ru Newsgroups: borland.public.interbase.replication Subject: Trouble with array fields replication Date: 13 Jul 2006 02:54:43 -0700 Organization: http://groups.google.com Lines: 45 Message-ID: <1152784483.060949.195380@s13g2000cwa.googlegroups.com> NNTP-Posting-Host: 62.33.232.135 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1152784489 32444 127.0.0.1 (13 Jul 2006 09:54:49 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 13 Jul 2006 09:54:49 +0000 (UTC) User-Agent: G2/0.2 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; ru) Opera 8.50,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: s13g2000cwa.googlegroups.com; posting-host=62.33.232.135; posting-account=EAXtZg0AAACjLuLgnBHMPvb-BQZ6HBpf