Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

primary Key

2 posts in Replication Last posting was on 2007-02-10 23:14:29.0Z
Paul Man Posted on 2007-02-10 23:03:54.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
Subject: primary Key
Date: Sat, 10 Feb 2007 23:03:54 -0000
Lines: 8
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45ce4ea9@solutions.advantagedatabase.com>
X-Trace: 10 Feb 2007 16:00:57 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:165
Article PK: 1134025

I tried to set up a primary index for use in replication. I cannot setup
this in ARC for a table by setting the index to primairy for each of the
fields required. ARC complains about one of the individual fields having
duplicate fields ( as it should have).

How do I create a primary key that is composed of several fields?


Paul Man Posted on 2007-02-10 23:14:29.0Z
From: "Paul Man" <paulman@datasoft.ie>
Newsgroups: advantage.Replication
References: <45ce4ea9@solutions.advantagedatabase.com>
Subject: Re: primary Key
Date: Sat, 10 Feb 2007 23:14:29 -0000
Lines: 21
Organization: DSoft
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 82.141.233.142
Message-ID: <45ce5125@solutions.advantagedatabase.com>
X-Trace: 10 Feb 2007 16:11:33 -0700, 82.141.233.142
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.141.233.142
Xref: solutions.advantagedatabase.com Advantage.Replication:166
Article PK: 1134023

I managed to find out. Create an index of the fields and then set the table
primary key to this.

Can I suggest that this be documented in the help as looking at ARC
(expecially if you have experienced Access for example) you could easily
think that simply marking each required field index as primary would
indicate a composite primary index whereas it is intended simply to set one
particular field to be the primary key.

"Paul Man" <paulman@datasoft.ie> wrote in message
news:45ce4ea9@solutions.advantagedatabase.com...
>I tried to set up a primary index for use in replication. I cannot setup
>this in ARC for a table by setting the index to primairy for each of the
>fields required. ARC complains about one of the individual fields having
>duplicate fields ( as it should have).
>
> How do I create a primary key that is composed of several fields?
>
>