>Hello,
>
>if you can help me, how i can make (pack) for my table in the midnight
Mohammed,
Sorry but I think it's early for you to attempt to use pack programmatically. Don't get this wrong, I'm just trying not to cause irreversibl damages.
Instead of a direct pack, you might :
use myTable exclusive && Error check if you can
Set deleted off
select deleted() as _deleted, * from myTable into table _Backup
set deleted on
select * from myTable into table _Temp
select myTable
zap
append from _temp
use in '_temp'
erase _temp.dbf
It's almost identical to a single pack but you take 2 backups (one with deleted ones marked witha flag) and in case a power failure occurs, you've at least 1 copy of good data.
Cetin