Keep highlighted row in place on a grid

[wtotten]

Hi,

I have looked here, and Google-ed this, and I can't find a solution, so I'll post this here and hope someone has an answer.

The pointer is on a row in the grid - say it's the fifth row in the grid. I have to rebuild the grid which includes changing its RecordSource - it stays the same - I'm not using a different data source, but the RecordSource property is reset by the grid "rebuild" code (I call the Grid.Init() and some other methods). The main reason I rebuild the grid is because I change the number of columns (note that setting Column[x].Visible isn't applicable for this app).

Once I do the rebuild of the grid I want the pointer to stay on the same record (not a problem - I can make that work) and I want the highlighted row to still be the fifth row in the grid (that's my problem).

Any ideas?

Thanks,
Bill

 

[EzLogic]

would going to that that record and refreshing the grid work?


HighlightRow = .t.
HighlightStyle = 2

I have one of my grids like that and i do the same thing.

before i rebuild it, i have an IID form the table, and when get the cursor.. i locate the IID and i refresh my grid.


Ali Koumaiha
TeknoSoft Inc.
Michigan

 

[wtotten]

That doesn't work. It does keep the pointer on the right record, but the grid scrolls on me.

 

[Olaf Doschke]

You have to use DoScroll and get ActiveRow to the same value as it was before.

Bye, Olaf.

 

[Mike Lewis]

Hi Bill,

Perhaps you can use the RelativeRow property to find the current row number. Save that to a variable before rebuilding the grid. Then, after you have rebuilt, use DoScroll to move the back to the saved row number.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy