FoxPro Grid

[bus1st]

I have a grid with two columns. The Record Source is a table that has two indexes to reference the data in the first and second columns. I put code in the header click events to change the order and refresh the grid. The problem is that I loose the record reference when I change the order between columns.

The code in each header click event is:
set order to index in table
thisform.grid.refresh()
thisform.grid.column.text.setfocus

If I am on record n in the first column when I click the header in the second column I do not maintain the same record number after I resort the second column.

 

[jimstarr]

Please clarify:

"If I am on record n in the first column...."

If you're on record n in the 1st column aren't you also on record n in the 2nd column? Unless your table is opened multiple times the record pointer can only be pointing to 1 record at a time.

Jim

 

[ramani]

Hi,
1. At the Form level create a variable called nRecord with 0 (Zero) as initial value.
2. In the AfterRowColChange event of the grid put the code,
ThisForm.nRecord = RECNO()
3. In the click event of the header add the following code at the end ..
Go ThisForm.nRecord

This will solve your problem ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[bus1st]

Preliminary test seems to work. Will let you know when I incorporate in my production code and test extensivly.

 

[TomasDill]

Hi!

If this is not too late, take a look to the FAQ article at the

http://www.universalthread.com

site:

http://www.universalthread.com/wconnect/wc.dll?UniversalThread~2,33,Forum=5,29,720

Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softservecom.com

The professional level of programmer could be determined by level of stupidity of his/her bugs