>>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,
Yeah, one of the issues is that there are many, many fields and I was just trying to simplify the process. I ended up doing an Append Blank with Scatter/Gather Name.
Renoir