Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert Into using Scatter Name?
Message
De
14/11/2001 16:40:22
 
 
À
14/11/2001 14:53:25
Jay Johengen
Altamahaw-Ossipee, Caroline du Nord, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00581723
Message ID:
00581786
Vues:
17
This message has been marked as a message which has helped to the initial question of the thread.
>For the sake of argument I do not want to use an Append for this...
>
>I want to take a record from the current view and insert it into a second one that has a similar structure, but not exact. I'm trying Scatter, but I do not want to use the MemVar clause as it causes scoping problems. I tried Scatter with an array, but when I Insert Into the view the values are out of order and populate in the wrong places (due to the differences in the structures I think). I was hoping there was an option to use Scatter Name and then Insert Into from the obect, but the Insert line causes a syntax error on compiling. Other than explicitly stating the Values in the Insert Into statement, what can I do? Thanks!
>
>Regards, Renoir

That method takes steps, something like:
scatter name oRecord
insert into mytable (keyID) values (oRecord.keyID)
select mytable
seek oRecord.keyID
gather name oRecord
< UPDATE >
I tested using SCATTER ... MEMVAR, then NSERT ... FROM MEMVAR in an isolated function, but it stomps all over local and private variables, even if they are variables from a calling program.
Steve Gibson
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform