Why not use...
INSERT INTO dbf_name [(fname1 [, fname2, ...])]
VALUES (eExpression1 [, eExpression2, ...])
or
INSERT INTO dbf_name VALUES (eExpression1 [, eExpression2, ...])
Note: If you omit the field names, you must specify the field values in the order defined by the table structure. If SET NULL is ON, INSERT – SQL attempts to insert null values into any fields not specified in the VALUES clause.

>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