Very Computer

This is the first time I have encounterd this Bug (BDE bug I think), and
here it is:
I'm using Delphi 2 C/S on win95 to connect to Sybase System 11 on NT
if you have a date at part of the key for a table, and the date column is
not the last item, then when you try to update that table from a grid (or
even Database Explorer), you get an error message saying
"Record/Key deleted" , on every record except the first record of every
set.

So for example if you have a key of client, adate, account, you will only
be able to edit the first record of each client

here is a code sample:
create the following 2 table using this code:

create table client1 (cli char(3) not null, vdate smalldatetime not null,
account char(5) not null, value float)

create table client2 (cli char(3) not null, account char(5) not null, vdate
smalldatetime not null, value float)

then create the following indexes using this code:

create unique unclustered index client1_ind on client1(cli, vdate, account)
create unique unclustered index client2_ind on client2(cli, account, vdate)

Add some data where you have more then 1 record per client.
Then try editing the value field in the table, you will see client1 give
you the problem, whereas client2 is fine.

If you try to update using SQL it works fine on both tables

Please fix this, or let me know if there is a fix for it.

Regards

Roman Vinnik

--
Roman Vinnik

Limon (Pty) Ltd

One possible solution is to make sure the grid have the filtered
property turned off and set other dependent (of the table) controls
to inactive, to prevent OnDataChanged events.

/Mikael