[RESOLVED] Option in ADODC or DataGrid components to update existing row?

[kutlesh]

I am using ADODC component with select query to feed the DataGrid component with data.

Everything works fine except, the thing I don't know how to update existing row instead of adding new one.
There are two columns in the datagrid which serve as keys. When i add another row with the same combination of those two key columns, the datagrid saves another row in the table.
Yes, the table should be set to have two keys, but its not, and i don't want to set keys, because its a legacy application and I might break other parts of it.

Is there some option to tell either ADODC or DataGrid component to update existing row with that same combination of keys instead of adding a new row?

Or I should add keys to my table, and explore where the application will break next?

[kutlesh]

Tried adding keys to the tables. DataGrid shows error message of adding rows with duplicate keys, but the form need to be closed to be used again

[DataMiser]

You have to edit the existing row

[Bobbles]

If you polled all of the experienced VB6 programmers, I reckon there would be very few using the Data Control.
Your choice, but I would recommend learning to use pure ADO code instead.
You will get better assistance if you do, because most of the experienced VB6 programmers are more familiar with the non Data Control approach.
Rob