E9.1 Read through only visible Grid records.

[FrankCLT]

HI All,

I have an application that I need to read through a grid, but only the visible records displayed not the hidden rows. I thought I had done this before but can't find any reference from my notes. Any ideas or pointers?

Thank you,
FrankCLT

 

[BOster]

Hmmm. I don't remember if there is a sys func that will determine if a grid row is displayed or hidden - I don't think there is. You may have to simply create a hidden CHAR 0/1 column that stores the hidden/displayed state and set it as you hide/display the grid rows. Then you can simply use that to determine if a row is hidden or displayed.

 

[JohnDanter2]

Is it not a comibation of
GetSelectedGridRowCount and then Get Next Selected Row

This is for selected grid rows, so the user has to click them all

// init variables
evt_iLineIn_INT01 = "0"
evt_iLineOut_INT01 = "0"
// get first row
Get Next Selected Row(FC Grid, <Before First Row>, evt_iLineOut_INT01)
While evt_iLineOut_INT01 is greater than evt_iLineIn_INT01
Get Grid Row(FC Grid, evt_iLineOut_INT01)
// do something with the GC
evt_iLineIn_INT01 = evt_iLineOut_INT01
Get Next Selected Row(FC Grid, evt_iLineIn_INT01, evt_iLineOut_INT01)
End While

 

[BOster]

The Selected Grid Row system functions are for rows that have been selected by the user and most only work when you have the property to select multiple grid rows set to true. They have nothing to do with visibility. When you loop the grid rows via normal grid iteration techniques, you will iterate over all grid rows whether they are visible or hidden.

 

[JohnDanter2]

Yeah I said that
(you can't select a hidden row can you, it's hidden)

 

[FrankCLT]

Thanks all......