In order for this site to work correctly we need to store a small file (called a cookie) on your computer. Most every site in the world does this, however since the 25th of May 2011, by law we have to get your permission first. Please abandon the forum if you disagree.

Para que este foro funcione correctamente es necesario guardar un pequeño fichero (llamado cookie) en su ordenador. La mayoría de los sitios de Internet lo hacen, no obstante desde el 25 de Marzo de 2011 y por ley, necesitamos de su permiso con antelación. Abandone este foro si no está conforme.

TDBBrowse

Xailer professional forum in English
Responder
Nick Hilder
Mensajes: 328
Registrado: Mar Nov 21, 2006 2:10 am

TDBBrowse

Mensaje por Nick Hilder »

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 JH
Mensajes: 358
Registrado: Lun Dic 10, 2007 5:10 pm

TDBBrowse

Mensaje por Ingo JH »

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 JH
Mensajes: 358
Registrado: Lun Dic 10, 2007 5:10 pm

TDBBrowse

Mensaje por Ingo JH »

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
>
Avatar de Usuario
ignacio
Site Admin
Mensajes: 9469
Registrado: Lun Abr 06, 2015 8:00 pm
Ubicación: Madrid, Spain
Contactar:

TDBBrowse

Mensaje por ignacio »

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
>>
>
Ignacio Ortiz de Zúñiga
[OZ Software]
https://www.ozs.es
--
[Equipo de Xailer / Xailer team]
https://www.xailer.com
NoName
Mensajes: 531
Registrado: Vie Feb 03, 2006 7:27 pm

TDBBrowse

Mensaje por NoName »

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
>>
>
Nick Hilder
Mensajes: 328
Registrado: Mar Nov 21, 2006 2:10 am

TDBBrowse

Mensaje por Nick Hilder »

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
>>
>
Nick Hilder
Mensajes: 328
Registrado: Mar Nov 21, 2006 2:10 am

TDBBrowse

Mensaje por Nick Hilder »

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
>>
>
Nick Hilder
Mensajes: 328
Registrado: Mar Nov 21, 2006 2:10 am

TDBBrowse

Mensaje por Nick Hilder »

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
>>>
>>
>
>
Nick Hilder
Mensajes: 328
Registrado: Mar Nov 21, 2006 2:10 am

TDBBrowse

Mensaje por Nick Hilder »

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
>>>
>>
>
>
Responder