>I am using the tastrade newid function. I want to copy data from one table to another table. In the new table, I need to assign surrogated key to each record. I tried using both APPEND FROM ARRAY or INSERT FROM ARRAY and the newid didn't seem to work. Am I correct? I know I can use SCAN+INSERT but is there a better way?
>
>Thanks in advance.
SCAN + INSERT may be the best way to do this. Unless you do a SQL-SELECT into array then USE newtable APPEND FROM ARRAY