How Can I remove (Pack) deleted records from my grid?

[MY3MCS]

I deleted some records from my grid, I want them to be totally remove (pack) from my database the moment I exited from the system. Can you please tell me what to do? Thanks.

 

[Mike Gagnon]

MY3MCS

Set deleted on in the init of the form (They will disappear once you refresh the form) and when you shutdown your application pack you table.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[MY3MCS]

Hey Mike:

Is there a place in the properties of my form wherein I can put the command pack? Or do I have to go to my command window and type this command:

USE (filename)
Pack

For me to totally remove the deleted records?

Thanks

 

[ramani]

HI

If file is already open.. first close it and then open it exclusive.

USE (filename) EXCLUSIVE
Pack




ramani
(Subramanian.G)

http://winnersoft.coolfreepages.com/

 

[mep1]

MY3MCS,
You can call pack from a button click.

oldWorkArea=select(0) && mark my place
use yourTable in yourTableAlias exclusive
select yourTable
pack
use yourTable in yourTableAlias shared
select (oldWorkArea)
thisform.refresh

This will open your table exclusively, delete the records marked for deletion, reopen the table shared, and then refresh the form to update the grid.

Hope this helps,
MEP1