General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>I've read warnings about using the PACK command to delete records.
>
>I have too, never heard about them actually happening though.
One easy way to avoid problems is to:
SELECT * FROM sometable WHERE !DELETED() INTO somecursor NOFILTER
SELECT sometable
PACK
*** If the PACK was successful, release the cursor.
*** Otherwise either delete the table and copy the
*** cursor to it or ZAP the table and append into
*** it from the cursor.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only