It's overkill to PACK a table after each delete. It should be done as maintanance operation not as a part of application regular run. Use SET DELETE ON to make deleted records "invisible" for your application. Keep in mind that SET DELETE ON is scooped to the current datasession.


>I've always had problems deleting a record from an open table.
>
>Here's the code:
>
>

>dele
>gfile=juststem(dbf())
>use in &gfile
>use &gfile in 0 alias gfile exclusive
>select gfile
>pack
>use
>

>
>And I get error file is in use in the 4th line. *sigh*
>
>Help pls.