IBReplicator don't support database which have CASE SENSITIVE field

Thread View: borland.public.interbase.replication

6 messages

[T] Back to Threads [V] Tree View [G] Group Articles

6 total messages Started by Noppadol Wed, 14 Jan 2004 11:16

#128

Author: 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.

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

#131

Author: Craig Stuntz TeamB
Date: Wed, 14 Jan 2004 14:03

16 lines
1536 bytes

Noppadol wrote:

> 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.

	One workaround would be to create a VIEW without the delimited
identifiers which simply wraps the table and replicate that instead of
the table.

	-Craig

-- 
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
  Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase 7 supports long-running transactions; read more here:
  http://delphi.weblogs.com/stories/storyReader$379

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

#130

Author: 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.
>
>

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

#132

Author: Paul Beach
Date: Wed, 14 Jan 2004 15:13

8 lines
1127 bytes

<snip>

You need to download IBReplicator V1.5 that supports SQL Delimited
Identifiers....
http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_replicator#DOWNLOAD

Regards
Paul

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

#134

Author: quinn wildman
Date: Wed, 14 Jan 2004 17:34

14 lines
1401 bytes

Note that any licensing you have purchased from Borland will not work 
with this version.

Paul Beach wrote:
> <snip>
> 
> You need to download IBReplicator V1.5 that supports SQL Delimited
> Identifiers....
> http://www.ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_replicator#DOWNLOAD
> 
> Regards
> Paul
> 
>

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

#135

Author: Paul Beach
Date: Thu, 15 Jan 2004 13:09

8 lines
1316 bytes

> Note that any licensing you have purchased from Borland will not work
> with this version.

It could do - if we wanted it to, the code to support Borland Licensing
(assuming it hasn't changed dramatically since Vince wrote the original code)
is still ifdeffed in the engine.

Paul

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