Information générale
Catégorie:
Codage, syntaxe et commandes
>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement