Hello Team
How to disappear empty records from a browser. With a pack a reindex after deleting? Please give me a layout how to use TDbfDataSet:pack and TdbfDataSet:Reindex methods on a multiuser environment. I call SET DELETED ON on the Initialization Form.
Many Thanks
Attached files
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 disappear empty records from the browser
- Dionisis Divaris
- Mensajes: 484
- Registrado: Jue Jul 12, 2007 8:48 pm
- Ubicación: Athens Greece
- ignacio
- Site Admin
- Mensajes: 9246
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
How to disappear empty records from the browser
Dionisis Divaris escribió el sáb, 16 agosto 2014 07:30Hello Team
How to disappear empty records from a browser. With a pack a reindex after deleting? Please give me a layout how to use TDbfDataSet:pack and TdbfDataSet:Reindex methods on a multiuser environment. I call SET DELETED ON on the Initialization Form.
Many Thanks
Try oBrose:Refresh( .t. )
Regards,
How to disappear empty records from a browser. With a pack a reindex after deleting? Please give me a layout how to use TDbfDataSet:pack and TdbfDataSet:Reindex methods on a multiuser environment. I call SET DELETED ON on the Initialization Form.
Many Thanks
Try oBrose:Refresh( .t. )
Regards,
- Dionisis Divaris
- Mensajes: 484
- Registrado: Jue Jul 12, 2007 8:48 pm
- Ubicación: Athens Greece
How to disappear empty records from the browser
Hello Ignacio
The oBrowse:Refresh (.t.) not help. Empty records continues to shown on the browser. Anything else?
Best Regards
The oBrowse:Refresh (.t.) not help. Empty records continues to shown on the browser. Anything else?
Best Regards
- ignacio
- Site Admin
- Mensajes: 9246
- Registrado: Lun Abr 06, 2015 8:00 pm
- Ubicación: Madrid, Spain
- Contactar:
How to disappear empty records from the browser
Hi,
I've changed sample DataControlsDbfData2 with the following code:
METHOD Delete() CLASS TForm1
if MsgYesNo( "Delete actual Record?" )
(::oDataSet:Alias)->(__dbzap())
::oDataSet:Refresh( .t. )
// ::oDataSet:Delete()
endif
RETURN NI
And it worked perfectly. BTW, I needed to to open the file in exclusive mode to do the job.
Regards,
Note: In a multi-user environment you can not perform any pack or reindex operation if you do not open the file in exclusive mode. In that mode the file can only be opened once. I'm missing something? TIA.
I've changed sample DataControlsDbfData2 with the following code:
METHOD Delete() CLASS TForm1
if MsgYesNo( "Delete actual Record?" )
(::oDataSet:Alias)->(__dbzap())
::oDataSet:Refresh( .t. )
// ::oDataSet:Delete()
endif
RETURN NI
And it worked perfectly. BTW, I needed to to open the file in exclusive mode to do the job.
Regards,
Note: In a multi-user environment you can not perform any pack or reindex operation if you do not open the file in exclusive mode. In that mode the file can only be opened once. I'm missing something? TIA.
-
- Mensajes: 291
- Registrado: Jue Ene 31, 2013 1:10 pm
How to disappear empty records from the browser
Dionisis,
maybe the "for !deleted()" clause is missing from the index expression?
Regards,
José Lalín
maybe the "for !deleted()" clause is missing from the index expression?
Regards,
José Lalín
- Dionisis Divaris
- Mensajes: 484
- Registrado: Jue Jul 12, 2007 8:48 pm
- Ubicación: Athens Greece
How to disappear empty records from the browser
Jose Ignacio
Many thanks for your help. The Jose solution (! Deleted() in Index command) do the job perfect.
Once again many thanks both of you.
Many thanks for your help. The Jose solution (! Deleted() in Index command) do the job perfect.
Once again many thanks both of you.
-
- Mensajes: 291
- Registrado: Jue Ene 31, 2013 1:10 pm
How to disappear empty records from the browser
Dionisis,
it was just a shoot in the dark
Regards,
José Lalín
it was just a shoot in the dark
Regards,
José Lalín