Hi Rixon

No, you can not pack it with SQL, SQL only marks records as deleted which is what it also should do. You will have to pack it yourself.

Why not use a cursor? Or put a 'pack-it' procedure in your startup routine? I strongly think you should re-think your design, packing a database is a BAD thing!


>Hi Tore, This is a temporary database table that needs to be overwritten each day. There's no real need to keep the data and we don't want to manually run a separate vfp program to pack the table. Is there a way to pack this as part of a SQL statement or a stored procedure? Thank.