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
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.
>
Steve Gibson