DataGrid

[thinman]

Hi all
I have already send similar message to this forum earlier, and hadn't find out the solution yet.
Basicly i have to querry recordsets. First is connected to a DataGrid control. I use second recordset for editing particular records. Well, after data is modified, i first call second recordset's Update method and then first recordset's Requery method, to asure that both recordsets have the same data. Well the thing is that DataGrid control doesn't reflect modifications made in second recordset.

Well, thanks for reading such a long post, and thanks in advance for any answering, thinman

[makai]

it works fine here with a grid and a textbox connected to 2 data controls

perhaps you need to close and reopen the 2nd recordset after the update to flush a buffer - not likely but it's the only thing I can think of

[thinman]

I'm using just one DataEnvironment designer, containing both querries!

Thanks, thinman

[michi]

Did you try DataGrid.Rebind or DataGrid.Refresh after rs.Requery? I didn't test yet, just an idea comes in my mind.

Regards,

Michi

[thinman]

It doesn't work. I've already tried that.
I tried to set DataGrid.DataMember property to DataGrid.DataMember value. This is the only way to refresh data in DataGrid.

Thinman