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.

Rdd ADS duplicated index key entires with xHarbour

10 posts in Clipper Last posting was on 2007-11-08 15:31:50.0Z
Antonio Ferreira Posted on 2007-11-02 09:49:11.0Z
From: "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt>
Newsgroups: advantage.clipper
Subject: Rdd ADS duplicated index key entires with xHarbour
Date: Fri, 2 Nov 2007 09:49:11 -0000
Lines: 11
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 81.84.210.208
Message-ID: <472af100@solutions.advantagedatabase.com>
X-Trace: 2 Nov 2007 03:42:24 -0700, 81.84.210.208
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!81.84.210.208
Xref: solutions.advantagedatabase.com Advantage.Clipper:4261
Article PK: 1106943

Hello,

I've found that for some reason I'm getting duplicated index key entries
although in the table there is only one record.
Does anyone knows what might be the problem ?

Regards
Antonio


Mark Wilkins Posted on 2007-11-02 13:59:58.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Fri, 2 Nov 2007 07:59:58 -0600
Lines: 29
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <472b2c24@solutions.advantagedatabase.com>
X-Trace: 2 Nov 2007 07:54:44 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Clipper:4263
Article PK: 1106942

Hi Antonio,

Is the index built on a character field? If so, then one possibility that
comes to mind is that the table has been modified with two different
collation sequences. If the collation language is changed, the tables must
be reindexed. Otherwise, any update to an existing record will result in
the original key not being removed because it would not be found. This can
be corrected simply by reindexing the table. If you are accessing the
tables with non-Advantage applications, then make sure that Advantage and
the other applications are using the same collation language.

Mark Wilkins
Advantage R&D

"Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
news:472af100@solutions.advantagedatabase.com...
> Hello,
>
> I've found that for some reason I'm getting duplicated index key entries
> although in the table there is only one record.
> Does anyone knows what might be the problem ?
>
> Regards
> Antonio
>
>
>


Antonio Ferreira Posted on 2007-11-02 15:51:52.0Z
From: "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com> <472b2c24@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Fri, 2 Nov 2007 15:51:52 -0000
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 81.84.210.208
Message-ID: <472b4601@solutions.advantagedatabase.com>
X-Trace: 2 Nov 2007 09:45:05 -0700, 81.84.210.208
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!81.84.210.208
Xref: solutions.advantagedatabase.com Advantage.Clipper:4264
Article PK: 1106944

Hi Mark,

In ADSLocall config file it is defined :

ANSI_CHAR_SET=Portuguese
OEM_CHAR_SET=PORTUGUE

But there is nothing in program code. Can this be the problem?

It doesn't only duplicate it repeats several times the same entrie. I've
found already 4.

On the other hand I was using the ADSkeyno and ADSkeycount to positioning
the scroll bars. I took this from the code and it seems that the problem
went away. Is this possible ? Do you have some explanation for it ?

Antonio



"Mark Wilkins" <mark@no.email> escreveu na mensagem
news:472b2c24@solutions.advantagedatabase.com...

> Hi Antonio,
>
> Is the index built on a character field? If so, then one possibility that
> comes to mind is that the table has been modified with two different
> collation sequences. If the collation language is changed, the tables
> must be reindexed. Otherwise, any update to an existing record will
> result in the original key not being removed because it would not be
> found. This can be corrected simply by reindexing the table. If you are
> accessing the tables with non-Advantage applications, then make sure that
> Advantage and the other applications are using the same collation
> language.
>
> Mark Wilkins
> Advantage R&D
>
> "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
> news:472af100@solutions.advantagedatabase.com...
>> Hello,
>>
>> I've found that for some reason I'm getting duplicated index key entries
>> although in the table there is only one record.
>> Does anyone knows what might be the problem ?
>>
>> Regards
>> Antonio
>>
>>
>>
>
>


Mark Wilkins Posted on 2007-11-02 16:06:59.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com> <472b2c24@solutions.advantagedatabase.com> <472b4601@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Fri, 2 Nov 2007 10:06:59 -0600
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <472b49e8@solutions.advantagedatabase.com>
X-Trace: 2 Nov 2007 10:01:44 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Clipper:4266
Article PK: 1106945

As long as all of the clients have those same entries in adslocal.ini, then
it should be fine. If one client, though, has different entries, then it
will cause problems. If you use Advantage Database Server, make sure it has
the same character set stamped into it (via the install or the
stampansioem.exe utility).

I don't actually know what underlying Advantage Client Engine functions are
called by ADSkeyno and ADSkeycount, but I am quite sure that those would not
lead to duplicate keys in the index. Those should be read/only functions.

How do you know there are multiple keys for one record? Are you looking at
the physical index with a hex editor? Or are you using some kind of index
corruption checking utility?

Thanks,
Mark Wilkins
Advantage R&D

"Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
news:472b4601@solutions.advantagedatabase.com...
> Hi Mark,
>
> In ADSLocall config file it is defined :
>
> ANSI_CHAR_SET=Portuguese
> OEM_CHAR_SET=PORTUGUE
>
> But there is nothing in program code. Can this be the problem?
>
> It doesn't only duplicate it repeats several times the same entrie. I've
> found already 4.
>
> On the other hand I was using the ADSkeyno and ADSkeycount to positioning
> the scroll bars. I took this from the code and it seems that the problem
> went away. Is this possible ? Do you have some explanation for it ?
>
> Antonio
>


Antonio Ferreira Posted on 2007-11-05 12:09:37.0Z
From: "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com> <472b2c24@solutions.advantagedatabase.com> <472b4601@solutions.advantagedatabase.com> <472b49e8@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Mon, 5 Nov 2007 12:09:37 -0000
Lines: 59
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.155.6.10
Message-ID: <472f39d5@solutions.advantagedatabase.com>
X-Trace: 5 Nov 2007 08:42:13 -0700, 82.155.6.10
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.155.6.10
Xref: solutions.advantagedatabase.com Advantage.Clipper:4267
Article PK: 1106947

Ok Adskeycount and AdsKeynr are not causing this problem.

I know there are multiple keys because I can see repeated records when the
index is active, although there are any in the table itself.
I can see it using the browse of the application or through arc32.exe.
I'm using local server.

Any ideas how to find a solution ?


Antonio

"Mark Wilkins" <mark@no.email> escreveu na mensagem
news:472b49e8@solutions.advantagedatabase.com...

> As long as all of the clients have those same entries in adslocal.ini,
> then it should be fine. If one client, though, has different entries,
> then it will cause problems. If you use Advantage Database Server, make
> sure it has the same character set stamped into it (via the install or the
> stampansioem.exe utility).
>
> I don't actually know what underlying Advantage Client Engine functions
> are called by ADSkeyno and ADSkeycount, but I am quite sure that those
> would not lead to duplicate keys in the index. Those should be read/only
> functions.
>
> How do you know there are multiple keys for one record? Are you looking
> at the physical index with a hex editor? Or are you using some kind of
> index corruption checking utility?
>
> Thanks,
> Mark Wilkins
> Advantage R&D
>
>
>
> "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
> news:472b4601@solutions.advantagedatabase.com...
>> Hi Mark,
>>
>> In ADSLocall config file it is defined :
>>
>> ANSI_CHAR_SET=Portuguese
>> OEM_CHAR_SET=PORTUGUE
>>
>> But there is nothing in program code. Can this be the problem?
>>
>> It doesn't only duplicate it repeats several times the same entrie. I've
>> found already 4.
>>
>> On the other hand I was using the ADSkeyno and ADSkeycount to positioning
>> the scroll bars. I took this from the code and it seems that the problem
>> went away. Is this possible ? Do you have some explanation for it ?
>>
>> Antonio
>>
>
>


Mark Wilkins Posted on 2007-11-06 15:17:21.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com> <472b2c24@solutions.advantagedatabase.com> <472b4601@solutions.advantagedatabase.com> <472b49e8@solutions.advantagedatabase.com> <472f39d5@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Tue, 6 Nov 2007 08:17:21 -0700
Lines: 73
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <47308446@solutions.advantagedatabase.com>
X-Trace: 6 Nov 2007 08:12:06 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Clipper:4269
Article PK: 1106948

It definitely sounds like there is a collation mismatch. The solution is to
make sure all clients use the same collation. Do you see the problem in the
ARC browser after you reindex the table? If you think it is a different
problem, please post the steps on how to re-create it.

Thanks,
Mark Wilkins
Advantage R&D

"Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
news:472f39d5@solutions.advantagedatabase.com...
> Ok Adskeycount and AdsKeynr are not causing this problem.
>
> I know there are multiple keys because I can see repeated records when the
> index is active, although there are any in the table itself.
> I can see it using the browse of the application or through arc32.exe.
> I'm using local server.
>
> Any ideas how to find a solution ?
>
>
> Antonio
>
> "Mark Wilkins" <mark@no.email> escreveu na mensagem
> news:472b49e8@solutions.advantagedatabase.com...
>> As long as all of the clients have those same entries in adslocal.ini,
>> then it should be fine. If one client, though, has different entries,
>> then it will cause problems. If you use Advantage Database Server, make
>> sure it has the same character set stamped into it (via the install or
>> the stampansioem.exe utility).
>>
>> I don't actually know what underlying Advantage Client Engine functions
>> are called by ADSkeyno and ADSkeycount, but I am quite sure that those
>> would not lead to duplicate keys in the index. Those should be read/only
>> functions.
>>
>> How do you know there are multiple keys for one record? Are you looking
>> at the physical index with a hex editor? Or are you using some kind of
>> index corruption checking utility?
>>
>> Thanks,
>> Mark Wilkins
>> Advantage R&D
>>
>>
>>
>> "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in
>> message news:472b4601@solutions.advantagedatabase.com...
>>> Hi Mark,
>>>
>>> In ADSLocall config file it is defined :
>>>
>>> ANSI_CHAR_SET=Portuguese
>>> OEM_CHAR_SET=PORTUGUE
>>>
>>> But there is nothing in program code. Can this be the problem?
>>>
>>> It doesn't only duplicate it repeats several times the same entrie. I've
>>> found already 4.
>>>
>>> On the other hand I was using the ADSkeyno and ADSkeycount to
>>> positioning the scroll bars. I took this from the code and it seems that
>>> the problem went away. Is this possible ? Do you have some explanation
>>> for it ?
>>>
>>> Antonio
>>>
>>
>>
>
>


Antonio Ferreira Posted on 2007-11-07 12:09:46.0Z
From: "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com> <472b2c24@solutions.advantagedatabase.com> <472b4601@solutions.advantagedatabase.com> <472b49e8@solutions.advantagedatabase.com> <472f39d5@solutions.advantagedatabase.com> <47308446@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Wed, 7 Nov 2007 12:09:46 -0000
Lines: 105
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.155.6.10
Message-ID: <4731a973@solutions.advantagedatabase.com>
X-Trace: 7 Nov 2007 05:02:59 -0700, 82.155.6.10
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.155.6.10
Xref: solutions.advantagedatabase.com Advantage.Clipper:4271
Article PK: 1106950

Mark,

The program rotine responsible for this repetition is not even updating any
of the indexed fields.
Example of the code :

index with field1 character c 13 only numbers and dots are possible + field2
character 3

alias1 related to alias2

do while ...
reg := recno()
do while ..
some calculations on vars
skip alias 1
enddo
go reg
if alias2 !eof
replace filed alias2 with var //this replace it's te faulty code
endif
skip alias1
enddo

What can be wrong?

Antonio

"Mark Wilkins" <mark@no.email> escreveu na mensagem
news:47308446@solutions.advantagedatabase.com...

> It definitely sounds like there is a collation mismatch. The solution is
> to make sure all clients use the same collation. Do you see the problem
> in the ARC browser after you reindex the table? If you think it is a
> different problem, please post the steps on how to re-create it.
>
> Thanks,
> Mark Wilkins
> Advantage R&D
>
> "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
> news:472f39d5@solutions.advantagedatabase.com...
>> Ok Adskeycount and AdsKeynr are not causing this problem.
>>
>> I know there are multiple keys because I can see repeated records when
>> the index is active, although there are any in the table itself.
>> I can see it using the browse of the application or through arc32.exe.
>> I'm using local server.
>>
>> Any ideas how to find a solution ?
>>
>>
>> Antonio
>>
>> "Mark Wilkins" <mark@no.email> escreveu na mensagem
>> news:472b49e8@solutions.advantagedatabase.com...
>>> As long as all of the clients have those same entries in adslocal.ini,
>>> then it should be fine. If one client, though, has different entries,
>>> then it will cause problems. If you use Advantage Database Server, make
>>> sure it has the same character set stamped into it (via the install or
>>> the stampansioem.exe utility).
>>>
>>> I don't actually know what underlying Advantage Client Engine functions
>>> are called by ADSkeyno and ADSkeycount, but I am quite sure that those
>>> would not lead to duplicate keys in the index. Those should be
>>> read/only functions.
>>>
>>> How do you know there are multiple keys for one record? Are you looking
>>> at the physical index with a hex editor? Or are you using some kind of
>>> index corruption checking utility?
>>>
>>> Thanks,
>>> Mark Wilkins
>>> Advantage R&D
>>>
>>>
>>>
>>> "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in
>>> message news:472b4601@solutions.advantagedatabase.com...
>>>> Hi Mark,
>>>>
>>>> In ADSLocall config file it is defined :
>>>>
>>>> ANSI_CHAR_SET=Portuguese
>>>> OEM_CHAR_SET=PORTUGUE
>>>>
>>>> But there is nothing in program code. Can this be the problem?
>>>>
>>>> It doesn't only duplicate it repeats several times the same entrie.
>>>> I've found already 4.
>>>>
>>>> On the other hand I was using the ADSkeyno and ADSkeycount to
>>>> positioning the scroll bars. I took this from the code and it seems
>>>> that the problem went away. Is this possible ? Do you have some
>>>> explanation for it ?
>>>>
>>>> Antonio
>>>>
>>>
>>>
>>
>>
>
>


Mark Wilkins Posted on 2007-11-08 15:31:50.0Z
From: "Mark Wilkins" <mark@no.email>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com> <472b2c24@solutions.advantagedatabase.com> <472b4601@solutions.advantagedatabase.com> <472b49e8@solutions.advantagedatabase.com> <472f39d5@solutions.advantagedatabase.com> <47308446@solutions.advantagedatabase.com> <4731a973@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Thu, 8 Nov 2007 08:31:50 -0700
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 10.24.38.228
Message-ID: <47332aaa@solutions.advantagedatabase.com>
X-Trace: 8 Nov 2007 08:26:34 -0700, 10.24.38.228
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.228
Xref: solutions.advantagedatabase.com Advantage.Clipper:4272
Article PK: 1106952

Have you reindexed the table? It sounds like the index has already been
corrupted in the past. If that is not the case, you could maybe send a
re-creation to Advantage technical support.

Mark Wilkins
Advantage R&D

"Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
news:4731a973@solutions.advantagedatabase.com...
> Mark,
>
> The program rotine responsible for this repetition is not even updating
> any of the indexed fields.
> Example of the code :
>


Massimo Belgrano Posted on 2007-11-07 10:32:01.0Z
From: "Massimo Belgrano" <mbelgranoREMOVEME@DELTAIN.COM>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com> <472b2c24@solutions.advantagedatabase.com> <472b4601@solutions.advantagedatabase.com> <472b49e8@solutions.advantagedatabase.com> <472f39d5@solutions.advantagedatabase.com> <47308446@solutions.advantagedatabase.com>
In-Reply-To: <47308446@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Wed, 7 Nov 2007 11:32:01 +0100
Lines: 78
Organization: Delta Informatica
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="iso-8859-1"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Windows Mail 6.0.6000.16480
X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545
NNTP-Posting-Host: 88.42.102.38
Message-ID: <473192f1@solutions.advantagedatabase.com>
X-Trace: 7 Nov 2007 03:26:57 -0700, 88.42.102.38
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!88.42.102.38
Xref: solutions.advantagedatabase.com Advantage.Clipper:4270
Article PK: 1106951

How is possible write on a log file the active collaction?

"Mark Wilkins" <mark@no.email> ha scritto nel messaggio
news:47308446@solutions.advantagedatabase.com...

> It definitely sounds like there is a collation mismatch. The solution is
> to make sure all clients use the same collation. Do you see the problem
> in the ARC browser after you reindex the table? If you think it is a
> different problem, please post the steps on how to re-create it.
>
> Thanks,
> Mark Wilkins
> Advantage R&D
>
> "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
> news:472f39d5@solutions.advantagedatabase.com...
>> Ok Adskeycount and AdsKeynr are not causing this problem.
>>
>> I know there are multiple keys because I can see repeated records when
>> the index is active, although there are any in the table itself.
>> I can see it using the browse of the application or through arc32.exe.
>> I'm using local server.
>>
>> Any ideas how to find a solution ?
>>
>>
>> Antonio
>>
>> "Mark Wilkins" <mark@no.email> escreveu na mensagem
>> news:472b49e8@solutions.advantagedatabase.com...
>>> As long as all of the clients have those same entries in adslocal.ini,
>>> then it should be fine. If one client, though, has different entries,
>>> then it will cause problems. If you use Advantage Database Server, make
>>> sure it has the same character set stamped into it (via the install or
>>> the stampansioem.exe utility).
>>>
>>> I don't actually know what underlying Advantage Client Engine functions
>>> are called by ADSkeyno and ADSkeycount, but I am quite sure that those
>>> would not lead to duplicate keys in the index. Those should be
>>> read/only functions.
>>>
>>> How do you know there are multiple keys for one record? Are you looking
>>> at the physical index with a hex editor? Or are you using some kind of
>>> index corruption checking utility?
>>>
>>> Thanks,
>>> Mark Wilkins
>>> Advantage R&D
>>>
>>>
>>>
>>> "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in
>>> message news:472b4601@solutions.advantagedatabase.com...
>>>> Hi Mark,
>>>>
>>>> In ADSLocall config file it is defined :
>>>>
>>>> ANSI_CHAR_SET=Portuguese
>>>> OEM_CHAR_SET=PORTUGUE
>>>>
>>>> But there is nothing in program code. Can this be the problem?
>>>>
>>>> It doesn't only duplicate it repeats several times the same entrie.
>>>> I've found already 4.
>>>>
>>>> On the other hand I was using the ADSkeyno and ADSkeycount to
>>>> positioning the scroll bars. I took this from the code and it seems
>>>> that the problem went away. Is this possible ? Do you have some
>>>> explanation for it ?
>>>>
>>>> Antonio
>>>>
>>>
>>>
>>
>>
>
>


Antonio Ferreira Posted on 2007-11-05 15:48:55.0Z
From: "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt>
Newsgroups: advantage.clipper
References: <472af100@solutions.advantagedatabase.com> <472b2c24@solutions.advantagedatabase.com> <472b4601@solutions.advantagedatabase.com> <472b49e8@solutions.advantagedatabase.com>
Subject: Re: Rdd ADS duplicated index key entires with xHarbour
Date: Mon, 5 Nov 2007 15:48:55 -0000
Lines: 59
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 82.155.6.10
Message-ID: <472f39d6@solutions.advantagedatabase.com>
X-Trace: 5 Nov 2007 08:42:14 -0700, 82.155.6.10
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!82.155.6.10
Xref: solutions.advantagedatabase.com Advantage.Clipper:4268
Article PK: 1106949

Ok Adskeycount and AdsKeynr are not causing this problem.

I know there are multiple keys because I can see repeated records when the
index is active, although there are any in the table itself.
I can see it using the browse of the application or through arc32.exe.
I'm using local server.

Any ideas how to find a solution ?


Antonio

"Mark Wilkins" <mark@no.email> escreveu na mensagem
news:472b49e8@solutions.advantagedatabase.com...

> As long as all of the clients have those same entries in adslocal.ini,
> then it should be fine. If one client, though, has different entries,
> then it will cause problems. If you use Advantage Database Server, make
> sure it has the same character set stamped into it (via the install or the
> stampansioem.exe utility).
>
> I don't actually know what underlying Advantage Client Engine functions
> are called by ADSkeyno and ADSkeycount, but I am quite sure that those
> would not lead to duplicate keys in the index. Those should be read/only
> functions.
>
> How do you know there are multiple keys for one record? Are you looking
> at the physical index with a hex editor? Or are you using some kind of
> index corruption checking utility?
>
> Thanks,
> Mark Wilkins
> Advantage R&D
>
>
>
> "Antonio Ferreira" <antonio-ferreira@m-homem-ferreira.pt> wrote in message
> news:472b4601@solutions.advantagedatabase.com...
>> Hi Mark,
>>
>> In ADSLocall config file it is defined :
>>
>> ANSI_CHAR_SET=Portuguese
>> OEM_CHAR_SET=PORTUGUE
>>
>> But there is nothing in program code. Can this be the problem?
>>
>> It doesn't only duplicate it repeats several times the same entrie. I've
>> found already 4.
>>
>> On the other hand I was using the ADSkeyno and ADSkeycount to positioning
>> the scroll bars. I took this from the code and it seems that the problem
>> went away. Is this possible ? Do you have some explanation for it ?
>>
>> Antonio
>>
>
>