Grid Scrollbar / Current Record Position

I'm using a grid on my form which pulls records from a view (SQL backend).

I perform a REFRESH(1,0,"MY_TABLE") each time I move rows to update the
underlying view with changes that may have been done across the network.

Problem is, when I use the scrollbar on a grid to move up and down the row
pointer doesn't change until the body of the grid has focus (i.e. I click on
it) so the records that are displayed are more often than not out of sync
with those in the backend database.

Is there any way of being able to update/refresh the view as the scroll
takes place so it reflects the true data?

Stefan
Tue Feb 05 04:47:20 CST 2008


"Andy Trezise" <andy@work.com> schrieb im Newsbeitrag
news:OAuCt49ZIHA.4196@TK2MSFTNGP04.phx.gbl...
> I'm using a grid on my form which pulls records from a view (SQL backend).
>
> Is there any way of being able to update/refresh the view as the scroll
> takes place so it reflects the true data?

Would the grid.Scrolled() event help?


hth
-Stefan




--
|\_/| ------ ProLib - programmers liberty -----------------
(.. ) Our MVPs and MCPs make the Fox run....
- / See us at www.prolib.de or www.AFPages.de
-----------------------------------------------------------

Andy
Tue Feb 05 10:15:06 CST 2008

I tried that but I still don't know how to establish which row (record) from
the underlying view is the first visible on screen so I know which to then
refresh

"Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
news:OnMA9R%23ZIHA.4140@TK2MSFTNGP04.phx.gbl...
>
> "Andy Trezise" <andy@work.com> schrieb im Newsbeitrag
> news:OAuCt49ZIHA.4196@TK2MSFTNGP04.phx.gbl...
>> I'm using a grid on my form which pulls records from a view (SQL
>> backend).
>>
>> Is there any way of being able to update/refresh the view as the scroll
>> takes place so it reflects the true data?
>
> Would the grid.Scrolled() event help?
>
>
> hth
> -Stefan
>
>
>
>
> --
> |\_/| ------ ProLib - programmers liberty -----------------
> (.. ) Our MVPs and MCPs make the Fox run....
> - / See us at www.prolib.de or www.AFPages.de
> -----------------------------------------------------------
>

Anders
Tue Feb 05 10:44:27 CST 2008

Grid.ActivateCell(1,1) puts the cursor in the topmost visible row of the
grid, column 1.

-Anders


"Andy Trezise" <andy@work.com> wrote in message
news:eYG0JLBaIHA.1532@TK2MSFTNGP04.phx.gbl...
>I tried that but I still don't know how to establish which row (record)
>from the underlying view is the first visible on screen so I know which to
>then refresh
>
> "Stefan Wuebbe" <stefan.wuebbe@gmx.de> wrote in message
> news:OnMA9R%23ZIHA.4140@TK2MSFTNGP04.phx.gbl...
>>
>> "Andy Trezise" <andy@work.com> schrieb im Newsbeitrag
>> news:OAuCt49ZIHA.4196@TK2MSFTNGP04.phx.gbl...
>>> I'm using a grid on my form which pulls records from a view (SQL
>>> backend).
>>>
>>> Is there any way of being able to update/refresh the view as the scroll
>>> takes place so it reflects the true data?
>>
>> Would the grid.Scrolled() event help?
>>
>>
>> hth
>> -Stefan
>>
>>
>>
>>
>> --
>> |\_/| ------ ProLib - programmers liberty -----------------
>> (.. ) Our MVPs and MCPs make the Fox run....
>> - / See us at www.prolib.de or www.AFPages.de
>> -----------------------------------------------------------
>>
>
>