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.
>
>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
Previous
Next
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