Board index » cppbuilder » Repeating records in TDBGrid/TTables

2004-07-15 05:08:42 AM
cppbuilder95
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.
 

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" < XXXX@XXXXX.COM >wrote in message