Ok, so let me ask the $64,000 question: Which method is faster or better: Append From DBF( or Insert Into as Gene used?
I have a similar project were I am issuing the same query to multiple SQL databases/servers and then using the Append From DBF( command to aggregate the results from each individual query into a large, single cursor to use for actual processing. I'm traveling today or I'd test this myself, but I have limited access. Figured I'd see if anyone else had already determined the best choice before I go poking around on my own. Paul -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Ted Roche Sent: Thursday, April 12, 2018 6:18 AM To: [email protected] Subject: Re: Appending from a Cursor On Wed, Apr 11, 2018 at 8:31 PM, Gene Wirchenko <[email protected]> wrote: > > I am puzzled why (alimport) works for the SQL but not the append from, > but whatever. > I agree with you that it is un-intuitive that aliases work *almost* everywhere. It's one of those hundreds of FoxPro's "always been that way" things. As others have said, APPEND FROM is ancient nearly-original XBase. While it was updated occasionally for new file formats, the main purpose of the command is a low-level IMPORT (sibling command) from foreign formats and not as a cursor-manipulation command, so it's intended for reading files-on-disk and not cursors. -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] 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/[email protected] ** 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.
