🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.interbase.replication
Article #130

Re: IBReplicator don't support database which have CASE SENSITIVE field

#130
From: Brian Ellul
Date: Wed, 14 Jan 2004 14:55
45 lines
2129 bytes
Dowload the new version (1.5) from

http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_replicator#DOWNLOAD

Brian

"Noppadol" <noppadol@intersol.co.th> wrote in message
news:400524fa$1@newsgroups.borland.com...
> 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: <400559ff@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.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
References: <400524fa$1@newsgroups.borland.com>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f89d7,da653787f80f1217
X-Google-Attributes: gidf89d7,public
X-Google-ArrivalTime: 2004-01-14 07:10:33 PST
From: "Brian Ellul" <brianellul@ecenglish.nospam.com>
Newsgroups: borland.public.interbase.replication
References: <400524fa$1@newsgroups.borland.com>
Subject: Re: IBReplicator don't support database which have CASE SENSITIVE field
Date: Wed, 14 Jan 2004 15:55:32 +0100
Lines: 47
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 62.173.4.213
Message-ID: <400559ff@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1074092543 62.173.4.213 (14 Jan 2004 07:02:23 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.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