General information
Category:
Coding, syntax & commands
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only