>>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...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.