>This time, I have included my E-mail address below. Sorry, I'm a new member and am just getting used to this interface.
>
>Original message:
>I am trying to create a set of routines for converting tables from a FP DOS 2.6 application to VFP 5.0. The source tables are "free" and the destination tables are configured within a database. Beginning with the most simple part of the problem, a lookup table with 2 columns and 7 rows and using APPEND FROM (VFP 5.0 documentation implies that INSERT INTO works with single row inserts only -- is that true?), I end up with 7 rows in the destination table, but the values are all NULL. The destination table has the same structure as the source table. It works correctly if I first export the source table to ASCII deilimited and "APPEND FROM" that file. I have read all documentation included with VFP that I can find on the subject. Any ideas will be very much appreciated.
>
>Kent
>roberts@sph.hbocvan.com
I use "append from" so rare that I don't have an exact idea why failed in your case. I use "insert into" and structures need not be the same.
use fp2xtable
scan
scatter memvar
insert into dbname!tablename from memvar
endscan
Cetin