Hi,
I'm processing about 250,000 records in Oracle, generating a text file from some of the recordsets.
During the time that the processing is taking place, you can't see any details on the form, and on the top is the standard 'not responding' message.
The application is clearly working, because if you wait long enough, it returns to the form, and the file is generated.
I tried putting in a status bar, which should show some basic information about the current record set, for every 5000 records.
After every
::sttSTatus:cText := sNthSql01_Records + " of " + sSql01_Records + ", " + sPersonId + ", " + sLastName + ", " + sFirstName
, I put in a
::frmAccountStatusList:Refresh()
, but the form still remains blank, even if you mouse click on it.
How do you get the form to remain visible, whenever it is activated?
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.
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.
How to avoid the Windows 'not responding' condition
-
orangesocks
- Mensajes: 59
- Registrado: Jue May 05, 2011 3:28 pm
How to avoid the Windows 'not responding' condition
Hi,
Use the function ProcessMessages() instead of ::frmAccountStatusList:Refresh(), which force the window to process all pending messages.
HTH
Giuseppe
Use the function ProcessMessages() instead of ::frmAccountStatusList:Refresh(), which force the window to process all pending messages.
HTH
Giuseppe
-
Guest
How to avoid the Windows 'not responding' condition
That worked, thanks Giuseppe
orangesocks wrote on Fri, 21 September 2012 19:23Hi,
Use the function ProcessMessages() instead of ::frmAccountStatusList:Refresh(), which force the window to process all pending messages.
HTH
Giuseppe
orangesocks wrote on Fri, 21 September 2012 19:23Hi,
Use the function ProcessMessages() instead of ::frmAccountStatusList:Refresh(), which force the window to process all pending messages.
HTH
Giuseppe