dataview update problems

[Tony Papadimitriou]

Hi,

Here's a short description of a problem that took me a couple of days
to bypass (not solve):

I update a table thru a dataview (or dataset, no difference in
behavior for this problem) and all but one column (a middle column,
if that matters) get updated when I do .acceptchanges

All columns are bound to textboxes with the textbox.bindings.add
("Text",dv.table,"column_name") method. I change the value in the
textbox and press Update which after some verification attempts to do
a dv.acceptchanges

Solution so far is to set the grid.currentrowindex to itself, then
do .acceptchanges like so:

grid.currentrowindex = grid.currentrowindex
dv.acceptchanges

But WHY is that needed? And why does it update the rest of the
columns but not all of them, without it?

Any ideas or explanations?

A second problem is that I can't get the dataview .sort property to work. I
set the column name but the view remains the same. Is there something more
one needs to do to force to sort to occur?

TIA

 

[Cor Ligthert]

Tony,

Can you show how you made that dataview, there is no dataview.acceptchanges.

I hop this helps,

Cor