>
>Once the program copies all records, I need to rename the TEMP_COPY to ORIG_FILE. Would the following sequence be a correct:
>1. Drop ORIG_FILE from the database
>2. Erase ORIG_FILE
>3. Rename TEMP_COPY to ORIG_FILE
>4. Add new ORIG_FILE to the database
>
One thing in the above sequence is definitely a problem. The table loses all index tags. And when I run Reindex routine from SDT, no index tags are created. I think this is due to the fact that when I DROP the Original table from the database, it removes all index tags definitions for this table from SDT and the database. So I guess I need to save the tags before removing and erasing the table.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham