>>>SET DATA TO etc
>>>SET DELE ON
>>>SELECT old (or USE old in 0)
>>>COPY TO temp DATA etc WITH CDX
>>>RENAME temp TO old && for file
>>>REMOVE TABLE old
>>>RENAME TABLE temp TO old && for DBC
>>
>>I've tried this and it chokes when you try to re-open the table. It's looking for the backlink. I'm inclined to agree with Kenneth's assessment now.
>
>I've tested it just now while waiting for a slow Sybase < s > query to run, and it works fine in the command window. As I said, if the path gets fouled up, it will cause trouble...but it does definitely work if done correctly. Do a simple case to see...
>
>That said, I agree with Kenneth :) The above method has got to referred to as "data gambling" or something like that, it's looking for some trouble...

Common lucky snake eyes. :)