On Wed, 06 Jul 2016 15:57:20 -0700, Gene Wirchenko <genew(a)telus.net> wrote:
>Hello:
>
> I ran into some trouble writing an update program for my
>app. Having not done it for quite a while, I forgot how to xBASE
>append from a cursor. A simple
> append from thecursorname
>does not work. Instead, I finally remembered the, rather less-than-obvious
> append from (dbf("thecursorname"))
>
> Is there a better way?
>
>Sincerely,
>
>Gene Wirchenko
Hi Gene,
your way in correct!
And then there is the SQL way:
insert into YourCursor ;
(Field1, Field2, Field3, FieldX) ;
select Field1, Field2, Field3, FieldX ;
from thecursorname
or
insert into YourCursor ;
select * ;
from thecursorname
Make sure that the implicit and / or explicit fields lists do match.
--
Gianni