I created a ADO and linked MSHFlexGrid boject to that ADO. When I select any record in the grid, how to find which recordset in that ADO object is selcted?
If I use
ADO_object.Recordset.Fields(0).Value
I always get first recordset's value
Pl help.
Printable View
I created a ADO and linked MSHFlexGrid boject to that ADO. When I select any record in the grid, how to find which recordset in that ADO object is selcted?
If I use
ADO_object.Recordset.Fields(0).Value
I always get first recordset's value
Pl help.
You could try:
MSHFlexgrid.Recordset.Fields(0).Value
Don't know if that will work, but it's worth a try :)
If you aren't doing sorting on the MSHFlexgrid, the following might work:
ADO_Object.Recordset.AbsolutePosition = MSHFlexGrid.Row
That should set the location in the record set to the current row of the flex grid.
Hope this helps,
Nathan Liebke