IBReplicator don't support database which have CASE SENSITIVE field

Article View: borland.public.interbase.replication

Article #128

Back to borland.public.interbase.replication Previous Next

#128

From: Noppadol
Date: Wed, 14 Jan 2004 11:16

33 lines
1859 bytes

I just install Licensing Interbase 7.1 and Licensing IBReplicator version
1.1.0 and trying to replicate two databases. My database was created by Case
Sensitive field name, like this

create table "Test1" (
"Id" integer not null,
"Description" varchar(30),
Primary Key ("Id")
);

when I create a schema completely then create system object , it show error

"...
Token unknown - ....
new.Id
"

It like an error when generating trigger on table "Test1".

When I create a new database by this sql

create table Test1 (
Id integer not null,
Description varchar(30),
Primary Key (Id)
);

I can create system object successfully.  That mean IBReplicator don't
support database which have CASE SENSITIVE field.
How should I do?   I don't need to create a new 'Non-case sensitive'
database because I must correct all SQL command in my program.

Regards.

Technical Details

Message-ID: <400524fa$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,da653787f80f1217,start
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2004-01-14 03:40:00 PST
Reply-To: "Noppadol" <noppadol@intersol.co.th>
From: "Noppadol" <noppadol@intersol.co.th>
Newsgroups: borland.public.interbase.replication
Subject: IBReplicator don't support database which have CASE SENSITIVE field
Date: Wed, 14 Jan 2004 18:16:00 +0700
Lines: 35
Organization: InterSol Consulting Co.,Ltd.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4807.1700
NNTP-Posting-Host: 202.125.96.5
Message-ID: <400524fa$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1074078970 202.125.96.5 (14 Jan 2004 03:16:10 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail