>Can anyone explain why the following command would display the "Overwrite?" dialog
twice if table StockBySize3 already exists? (SET("SAFETY") = "ON"). The end-result is still correct.
>
>
>select * from StockBySize;
> union select * from StockBySize2;
> into table StockBySize3
>
>
>(Using VFP 6, SP5)
Adding another union gives 3 "Overwrite" dialog's. I'm guessing that each select writes to the table as it is performed, rather than creating a temporary table then copying to the final table.
Len Speed