Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Into using Scatter Name?
Message
From
15/11/2001 07:59:18
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00581723
Message ID:
00581978
Views:
22
>>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
>
>Unfortunately, nothing. There was a discussion few months ago and this is a wish for new VFP version. However, there is no command insert from name oVars.
>
>You can append blank, then gather name myObject memo. Would it be sufficient?

Nadya,

Yes, that is what I ended up doing, but I thought it should be easier. I hope this makes it into the next version. Maybe I could write a function to handle this so it would loop through the fields and at least seem to work like an object.

Renoir
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform