> In my program I need to append several tables (cursors?) to a table
> (cursor) is this possible to do?
> Is there some other func. witch does the same, with cursors?
>
> Best regards
>
> Per Simmersholm
You simply Append From, but there is a little trick - append statement
expects a filename, not an alias, so if you have
sele * from a_table into curs tmp
sele b_table
appe from tmp
you get an error "tmp.dbf does not exist" or something like that. You
have to
appe from (dbf("tmp"))
this way you get the real filename of the cursor in a name expression,
and give it to the append statement. Rules for append still apply - only
the fields with matching names will be appended, the others will be
blank, and you'd be surprised how much of string to numeric (not sure of
this) or vice versa (this sure works) conversion is done automatically.