Unfortunately, I do have memo fields. Can an array hold memo values? If so, I guess I can always do select into array and then insert fields into the second table.

Thanks
Nick Patel

>Hi Nick,
>
>You are correct. SELECT ... INTO TABLE creates a new table.
>
>Are there any memo fields involved? You can use a SCATTER/GATHER NAME approach to get the non-memo fields.
>
>

>select lv_veh
>scatter name oFields
>select vehicle_arc
>append blank   && your new record should get the uniqueID
>gather name oFields
>

>
>HTH
>
>>Thanks for answering. I was trying the following. The table that this data is going into generates a uniqueid in one of those extra fields I mentioned (a nextid.prg in the table stuctures default values).
>>
>>

>>select vehicle_arc
>>SELECT * from lv_veh WHERE lv_veh.v_id = .a INTO TABLE vehicle_arc
>>TABLEUPDATE(.t.,.t.,'vehicle_arc')
>>

>>
>< snip >
>>It is almost as if the INTO command is trying to create a new table. I want it to go to existing table. The Scatter, Gather command won't automatically create the uniqueid, guess it doesn't work unless I do somekind of SQL command. I works when I do INSERT.
>>