Re: xBASE Appending from a Cursor

On Wed, 06 Jul 2016 15:57:20 -0700, Gene Wirchenko genew@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.