>Greetings,
>
>I have a simple grid tied to a table and a command button to delete the current record. If I just mark the record as DELETEd, the grid shows the record as marked. However, if I issue a PACK, the grid immediately disappears. It does not matter whether I am removing the record or keeping others.
>
>If I use an ADD button on the screen, a record is added to the table, but the grid will still not redisplay unless I restart the application. Any ideas?
>
>Thanks!
>
>Michael Reynolds

Hi Michael,
PACK is a maintenance command and you wouldn't normally use it in a user environment. When it is issued it closes down the link to the database temporarily - so the grid looses it's bindings to the data.
To hide deleted records use SET DELETED ON and refresh the grid.
Remember that SET DELETED and many other set commands are scoped to the datasession (eg a form with private datasession)

I'd normally only PACK as a maintenance run once a week or once a month depending on the intensity of the application and the file sizes.

HTH