Mensaje
General information
Foro:
Visual FoxPro
Category:
Bases de datos, tablas, vistas, índices y SQL
Miscellaneous
ID de la conversación:
00352881
ID del mensaje:
00352922
Views:
20
>If I use an append from, will the extra field in table2 cause a problem?, since the extra field has a default value that generates unique id (nextid.prg), append from doesn't seem to fire this default value, only insert into.

If you have to use INSERT INTO then:
select table2
scan
   scatter memvar memo
   insert into table1 from memvar
endscan
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Responder
Mapa
Ver