>>>WOW!
>>>
>>>WHile it wasn't really an answer to the question, it presented a fabulous solution - I can't believe in all the threads, nobody mentioned the zap solution
>>>
>>>Thanks so much
>>
>>Joseph,
>>Warn : You're sailing in dangerous waters :)
>>ie: You select into a cursor, zap and power fails. Bye bye data.
>>Cetin
>
>Just my 2 cents but the same thing can happen with the PACK command.
>
>Also we only use this on tempary data files that we selected out to allow the user to edit then we go back and update the live tables after they hit save.
Not exactly, pack is safer but to be honest I don't give pack into user's hands out of maintanence routines.
Then why do you pack a temp table :) Set deleted on.
oops meant cursor (a temp would be likely to be)
Cetin