BorlandTalk.com

Robert Wheadon · Guest

Hello,

I am writing a BCB 5 application using Borland Database components against
an Access '97 database. I have a table where the primary key is an
AutoIncrement number and the secondary key is a sorted list of names. The
name list works fine in some cases but when I change the capitalisation of
one of the names, I get repeating sequences in the grid. For example. Say
if I had three names in the Grid: A, B, C. The grid would display them
OK.

A
B
C

But if I was to rename 'A' to 'a' (changing the case). I would get
something like

a
B
C
a
B
C

Moving the cursor up and down the grid can also expand the list.

This is very strange behaviour. Has anyone seen this sort of thing before?

Any help would be appreciated.

Thanks,

Robert Wheadon.

George · Guest

Robert

All I can observe is that funny things happen when you include auto-inc
numbers in keys and combining that with a sorted list, (how do you do that?)
could produce odd results.

Just an observation.

George

"Robert Wheadon" <robert.wheadon (AT) monitorbm (DOT) co.nz> wrote