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.

How to disappear empty records from the browser

Xailer professional forum in English
Responder
Avatar de Usuario
Dionisis Divaris
Mensajes: 484
Registrado: Jue Jul 12, 2007 8:48 pm
Ubicación: Athens Greece

How to disappear empty records from the browser

Mensaje por Dionisis Divaris »

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
T.I.A
Dionisis
SGS-soft
support.sgs@gmail.com
Avatar de Usuario
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

Mensaje por ignacio »

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,
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
https://www.xailer.com
Avatar de Usuario
Dionisis Divaris
Mensajes: 484
Registrado: Jue Jul 12, 2007 8:48 pm
Ubicación: Athens Greece

How to disappear empty records from the browser

Mensaje por Dionisis Divaris »

Hello Ignacio
The oBrowse:Refresh (.t.) not help. Empty records continues to shown on the browser. Anything else?
Best Regards
T.I.A
Dionisis
SGS-soft
support.sgs@gmail.com
Avatar de Usuario
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

Mensaje por ignacio »

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.
Ignacio Ortiz de Zúñiga
[Equipo de Xailer / Xailer team]
https://www.xailer.com
joselalinf
Mensajes: 291
Registrado: Jue Ene 31, 2013 1:10 pm

How to disappear empty records from the browser

Mensaje por joselalinf »

Dionisis,
maybe the "for !deleted()" clause is missing from the index expression?
Regards,
José Lalí­n
Avatar de Usuario
Dionisis Divaris
Mensajes: 484
Registrado: Jue Jul 12, 2007 8:48 pm
Ubicación: Athens Greece

How to disappear empty records from the browser

Mensaje por Dionisis Divaris »

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.
T.I.A
Dionisis
SGS-soft
support.sgs@gmail.com
joselalinf
Mensajes: 291
Registrado: Jue Ene 31, 2013 1:10 pm

How to disappear empty records from the browser

Mensaje por joselalinf »

Dionisis,
it was just a shoot in the dark ;-)
Regards,
José Lalí­n
Responder