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:profoxtech-bounces@leafe.com] On Behalf Of Ted Roche Sent: Thursday, April 12, 2018 6:18 AM To: profoxtech@leafe.com Subject: Re: Appending from a Cursor
On Wed, Apr 11, 2018 at 8:31 PM, Gene Wirchenko genew@telus.net 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.