On Wed, 06 Jul 2016 15:57:20 -0700, Gene Wirchenko <ge...@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 _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/c35rnb1ll8cp5003fdc3fbdiat986fl...@4ax.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.