>>>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.
>>
>>If NewID() is available (by placing it in the stored procedures of your DBC) and you have NewId() as default value for your primary key field, all should be fine. You can even try this interactively.
>>
>>José
>
>I found that SELECT ...INTO ARRAY ... followed by APPEND FROM ARRAY ... or INSERT FROM ARRAY .... doesn't take default value. You have to do SELECT .. INTO CURSOR followed by APPEND FROM ARRAY or INSERT FROM ARRAY
Shihchau,
I never implied arrays would take a default value, how would they? And I don't quite get why you are dealing with arrays in this case.
José