>Hello all,
>I can't figure this one out. Trying to create a temp table, insert my data move it to a text file and then delete temp table for reuse. The first time it works great, when I try to use the table again, I get an error "invalid duplicate name". any suggestions???
>LOCAL KELLY
>CREATE TABLE KELLY FREE;
> (country C(25), carrier_code C(50), country_code C(25),;
> level_num I(4), b_partition I(4), sunday C(1), monday C(1), tuesday C(1), wednesday C(1),thursday C(1), friday C(1), ; saturday C(1), holiday C(1), last_min_valid I(4))
>
>
>INSERT INTO KELLY (country, carrier_code, country_code,;
> level_num, b_partition, sunday, monday, tuesday, wednesday,;
> thursday, friday, saturday, holiday, last_min_valid);
> VALUES(batch_view.city, batch_view.carrier_code,; batch_view.exp,1,6, "1", "1", "1", "1", "1", "1", "1", "1", 1440)
>COPY TO (THISFORM.Combo1.VALUE + ".txt") TYPE DELIMITED
>(under a delete command button:click)
>CLOSE DATA ALL
>DELETE FROM KELLY
>PACK
>CLOSE DATA ALL
>DROP TABLE KELLY
>
>Thanks Kelly

---

You can use cursor instead of table.