Grid ActiveRow

[TheBlainer]

Hi,

I have a little problem and it seems so simple that it doesn't work. I have a grid that has a Sql statement as RecordSource and the data returned inside my grid is fine.
I have a button on my form that need to interact with the grid. So I need the ActiveRow of the grid and for that I thought the property ActiveRow from the grid would work, but it gives me 0 all the times. Same case with the property RelativeRow.

So can anyone tell what is wrong with what I'm doing?
Thanks

TheBlainer

 

[Mike Lewis]

What is the setting of the AllowCellSelection property? If it is .F., that might explain the behaviour you are seeing.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Mike Lewis]

Also, the ActiveRow will be zero if the grid doesn't have focus (which is probably the case here). Try executing THISFORM.MyGrid.SetFocus immediately before testing ActiveRow.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[TheBlainer]

I understand what you're saying Mike and it makes sense, but it still gives me 0...
I found another solution, I put my sql statement in a cursor and I do a Select nameOfCursor after.
With that I can use RECNO() to have the row.

So thanks Mike for trying to help.

TheBlainer

 

[Olaf Doschke]

Even if you have a recordsource of a table, the activerow of the grid positions in the record, the current row is the grids activerow.

Bye, Olaf.

 

[Mike Lewis]

Yes, using the record in the underlying cursor is a better solution. I was going to suggest that, but I wasn't sure how to get the alias of the cursor when you were using a SQL statement as the record source. But doing the SQL outside of the grid, and using the cursor as the record source, makes good sense.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[Olaf Doschke]

The alias of a Sql statement as RecordSource would most probably be "Query" Unless you sepcify "...INTO CURSOR curGrid" or something along those lines. You really gain more control not using this type of recordsource and doing the query or whatever code to generate a cursor before or at least in grid.init().

Bye, Olaf.

 

[Mike Lewis]

I agree, Olaf. I've never used a SQL statement directly as a record source. I nearly always create a cursor first.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[hassanovich]

ActiveRow returns zero if the grid doesn't have the focus or when you access a row outside the grid display.
but try to access ActiveRow inside the grid.
here is an exemple :
put this code snipet

thisform.text1.value = thisform.mygrid.ActiveRow
in
mygrid.column1.text1.click()

it works

Regards

Hassan