Xailer & OZ Software

Hi Gents
I have DBBrowse on a form
Every few seconds I loop through the underlying database to see if any new
records have appeared.
At the moment, as I skip through the records underneath, the grid on screen
reflects this. So the users can't click on a row easily as I'm moving the
record pointer every few seconds.
How do I tell the browse not to move the record selector on screen?
Nick

Nick,
I'm using oDataSet:SaveState( .T. ) .. oDataSet:RestoreState( .T. ) to stop
updating the browse during moving the database pointer.
See the documentation:
With object oDataSet
// Save state and update the DataControls
:SaveState( .t. )
:GoTop()
// All this moves will not affect to the DataControls
Do While !:Eof()
.....
:Skip()
Enddo
// It will recover the table state and the DataControls start to receive
events.
:RestoreState( .t. )
End with
Regards
Ingo
"Nick Hilder" <nick_n0_spam_atcapsol.com.au> schrieb im Newsbeitrag
news:4885601a$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Hi Gents
>
> I have DBBrowse on a form
>
> Every few seconds I loop through the underlying database to see if any new
> records have appeared.
>
> At the moment, as I skip through the records underneath, the grid on
> screen reflects this. So the users can't click on a row easily as I'm
> moving the record pointer every few seconds.
>
> How do I tell the browse not to move the record selector on screen?
>
> Nick
>

Nick,
I'm using oDataSet:SaveState( .T. ) .. oDataSet:RestoreState( .T. ) to stop
updating the browse during moving the database pointer.
See the documentation:
With object oDataSet
// Save state and update the DataControls
:SaveState( .t. )
:GoTop()
// All this moves will not affect to the DataControls
Do While !:Eof()
.....
:Skip()
Enddo
// It will recover the table state and the DataControls start to receive
events.
:RestoreState( .t. )
End with
Regards
Ingo
"Nick Hilder" <nick_n0_spam_atcapsol.com.au> schrieb im Newsbeitrag
news:4885601a$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Hi Gents
>
> I have DBBrowse on a form
>
> Every few seconds I loop through the underlying database to see if any new
> records have appeared.
>
> At the moment, as I skip through the records underneath, the grid on
> screen reflects this. So the users can't click on a row easily as I'm
> moving the record pointer every few seconds.
>
> How do I tell the browse not to move the record selector on screen?
>
> Nick
>

Ingo,
Thanks for that. I could not say it better.
Regards,
--
Ignacio Ortiz de Zúñiga
[Soporte Xailer]
[Xailer support]
"Ingo" <support@mandantwin.com> escribió en el mensaje
news:48856b4b$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Nick,
>
> I'm using oDataSet:SaveState( .T. ) .. oDataSet:RestoreState( .T. ) to
> stop
> updating the browse during moving the database pointer.
> See the documentation:
>
> With object oDataSet
>
> // Save state and update the DataControls
>
> :SaveState( .t. )
>
> :GoTop()
>
> // All this moves will not affect to the DataControls
>
> Do While !:Eof()
>
> .....
>
> :Skip()
>
> Enddo
>
> // It will recover the table state and the DataControls start to receive
> events.
>
> :RestoreState( .t. )
>
> End with
>
> Regards
>
> Ingo
>
>
> "Nick Hilder" <nick_n0_spam_atcapsol.com.au> schrieb im Newsbeitrag
> news:4885601a$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> Hi Gents
>>
>> I have DBBrowse on a form
>>
>> Every few seconds I loop through the underlying database to see if any
>> new records have appeared.
>>
>> At the moment, as I skip through the records underneath, the grid on
>> screen reflects this. So the users can't click on a row easily as I'm
>> moving the record pointer every few seconds.
>>
>> How do I tell the browse not to move the record selector on screen?
>>
>> Nick
>>
>

Ingo,
Thanks for that. I could not say it better.
Regards,
--
Ignacio Ortiz de Zúñiga
[Soporte Xailer]
[Xailer support]
"Ingo" <support@mandantwin.com> escribió en el mensaje
news:48856b4b$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Nick,
>
> I'm using oDataSet:SaveState( .T. ) .. oDataSet:RestoreState( .T. ) to
> stop
> updating the browse during moving the database pointer.
> See the documentation:
>
> With object oDataSet
>
> // Save state and update the DataControls
>
> :SaveState( .t. )
>
> :GoTop()
>
> // All this moves will not affect to the DataControls
>
> Do While !:Eof()
>
> .....
>
> :Skip()
>
> Enddo
>
> // It will recover the table state and the DataControls start to receive
> events.
>
> :RestoreState( .t. )
>
> End with
>
> Regards
>
> Ingo
>
>
> "Nick Hilder" <nick_n0_spam_atcapsol.com.au> schrieb im Newsbeitrag
> news:4885601a$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> Hi Gents
>>
>> I have DBBrowse on a form
>>
>> Every few seconds I loop through the underlying database to see if any
>> new records have appeared.
>>
>> At the moment, as I skip through the records underneath, the grid on
>> screen reflects this. So the users can't click on a row easily as I'm
>> moving the record pointer every few seconds.
>>
>> How do I tell the browse not to move the record selector on screen?
>>
>> Nick
>>
>

Thanks Ingo....
I shall give it a try
"Ingo" <support@mandantwin.com> wrote in message
news:48856b4b$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Nick,
>
> I'm using oDataSet:SaveState( .T. ) .. oDataSet:RestoreState( .T. ) to
> stop
> updating the browse during moving the database pointer.
> See the documentation:
>
> With object oDataSet
>
> // Save state and update the DataControls
>
> :SaveState( .t. )
>
> :GoTop()
>
> // All this moves will not affect to the DataControls
>
> Do While !:Eof()
>
> .....
>
> :Skip()
>
> Enddo
>
> // It will recover the table state and the DataControls start to receive
> events.
>
> :RestoreState( .t. )
>
> End with
>
> Regards
>
> Ingo
>
>
> "Nick Hilder" <nick_n0_spam_atcapsol.com.au> schrieb im Newsbeitrag
> news:4885601a$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> Hi Gents
>>
>> I have DBBrowse on a form
>>
>> Every few seconds I loop through the underlying database to see if any
>> new records have appeared.
>>
>> At the moment, as I skip through the records underneath, the grid on
>> screen reflects this. So the users can't click on a row easily as I'm
>> moving the record pointer every few seconds.
>>
>> How do I tell the browse not to move the record selector on screen?
>>
>> Nick
>>
>

Thanks Ingo....
I shall give it a try
"Ingo" <support@mandantwin.com> wrote in message
news:48856b4b$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Nick,
>
> I'm using oDataSet:SaveState( .T. ) .. oDataSet:RestoreState( .T. ) to
> stop
> updating the browse during moving the database pointer.
> See the documentation:
>
> With object oDataSet
>
> // Save state and update the DataControls
>
> :SaveState( .t. )
>
> :GoTop()
>
> // All this moves will not affect to the DataControls
>
> Do While !:Eof()
>
> .....
>
> :Skip()
>
> Enddo
>
> // It will recover the table state and the DataControls start to receive
> events.
>
> :RestoreState( .t. )
>
> End with
>
> Regards
>
> Ingo
>
>
> "Nick Hilder" <nick_n0_spam_atcapsol.com.au> schrieb im Newsbeitrag
> news:4885601a$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> Hi Gents
>>
>> I have DBBrowse on a form
>>
>> Every few seconds I loop through the underlying database to see if any
>> new records have appeared.
>>
>> At the moment, as I skip through the records underneath, the grid on
>> screen reflects this. So the users can't click on a row easily as I'm
>> moving the record pointer every few seconds.
>>
>> How do I tell the browse not to move the record selector on screen?
>>
>> Nick
>>
>

Xailer rules again. Two lines in my Read method and now no more looping in
the browse.
The customer will be very happy..and me too.
"Nick Hilder" <nick_n0_spam_atcapsol.com.au> wrote in message
news:488678b6$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Thanks Ingo....
>
> I shall give it a try
>
>
>
> "Ingo" <support@mandantwin.com> wrote in message
> news:48856b4b$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> Nick,
>>
>> I'm using oDataSet:SaveState( .T. ) .. oDataSet:RestoreState( .T. ) to
>> stop
>> updating the browse during moving the database pointer.
>> See the documentation:
>>
>> With object oDataSet
>>
>> // Save state and update the DataControls
>>
>> :SaveState( .t. )
>>
>> :GoTop()
>>
>> // All this moves will not affect to the DataControls
>>
>> Do While !:Eof()
>>
>> .....
>>
>> :Skip()
>>
>> Enddo
>>
>> // It will recover the table state and the DataControls start to
>> receive
>> events.
>>
>> :RestoreState( .t. )
>>
>> End with
>>
>> Regards
>>
>> Ingo
>>
>>
>> "Nick Hilder" <nick_n0_spam_atcapsol.com.au> schrieb im Newsbeitrag
>> news:4885601a$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>>> Hi Gents
>>>
>>> I have DBBrowse on a form
>>>
>>> Every few seconds I loop through the underlying database to see if any
>>> new records have appeared.
>>>
>>> At the moment, as I skip through the records underneath, the grid on
>>> screen reflects this. So the users can't click on a row easily as I'm
>>> moving the record pointer every few seconds.
>>>
>>> How do I tell the browse not to move the record selector on screen?
>>>
>>> Nick
>>>
>>
>
>

Xailer rules again. Two lines in my Read method and now no more looping in
the browse.
The customer will be very happy..and me too.
"Nick Hilder" <nick_n0_spam_atcapsol.com.au> wrote in message
news:488678b6$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
> Thanks Ingo....
>
> I shall give it a try
>
>
>
> "Ingo" <support@mandantwin.com> wrote in message
> news:48856b4b$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>> Nick,
>>
>> I'm using oDataSet:SaveState( .T. ) .. oDataSet:RestoreState( .T. ) to
>> stop
>> updating the browse during moving the database pointer.
>> See the documentation:
>>
>> With object oDataSet
>>
>> // Save state and update the DataControls
>>
>> :SaveState( .t. )
>>
>> :GoTop()
>>
>> // All this moves will not affect to the DataControls
>>
>> Do While !:Eof()
>>
>> .....
>>
>> :Skip()
>>
>> Enddo
>>
>> // It will recover the table state and the DataControls start to
>> receive
>> events.
>>
>> :RestoreState( .t. )
>>
>> End with
>>
>> Regards
>>
>> Ingo
>>
>>
>> "Nick Hilder" <nick_n0_spam_atcapsol.com.au> schrieb im Newsbeitrag
>> news:4885601a$[email=1@ozsrv2.ozlan.local...]1@ozsrv2.ozlan.local...[/email]
>>> Hi Gents
>>>
>>> I have DBBrowse on a form
>>>
>>> Every few seconds I loop through the underlying database to see if any
>>> new records have appeared.
>>>
>>> At the moment, as I skip through the records underneath, the grid on
>>> screen reflects this. So the users can't click on a row easily as I'm
>>> moving the record pointer every few seconds.
>>>
>>> How do I tell the browse not to move the record selector on screen?
>>>
>>> Nick
>>>
>>
>
>