Re: Appending from a Cursor

On Wed, Apr 11, 2018 at 8:31 PM, Gene Wirchenko 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

Re: Appending from a Cursor

Append from dbf('yourcursor') Rafael Copquin El mié., 11 de abr. de 2018 15:02, Gene Wirchenko escribió: > Hello: > > I have some code where I am importing transactions. I have a > cursor for these transactions where I validate them. After doing > this, I want to add

Re: Appending from a Cursor

Hi Gene, 'append from' appends data from a file on the disk and a cursor is not a file ! Can you try this : APPEND FROM (DBF(m.alimport)) The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance:

Re: Appending from a Cursor

On Thu, 12 Apr 2018, at 2:18 PM, Paul H. Tarver wrote: > 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 remember seeing on fox.wikis.com that Insert-SQL can be up to 100x faster than Append from. Not sure how true that

Re: Appending from a Cursor

On Thu, 12 Apr 2018, at 1:31 PM, Jean MAURICE wrote: > Hi Gene, > > 'append from' appends data from a file on the disk and a cursor is not a file > ! A cursor may or may not have a disk presence depending on various factors. But SQL is a a better way to do it. insert into mytable (f1, f2,

RE: Appending from a Cursor

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

RE: Appending from a Cursor

As Ted would say, it depends on your environment. I doubt you will see any significant performance difference with a 100 row table. Big tables? Rotational vs SSD? -- rk -Original Message- From: ProfoxTech On Behalf Of Alan Bourke Sent: Thursday, April

Re: Appending from a Cursor

I was planning a similar test to get some sense of the quantifiable difference but you did a great job, Dave! The verdict is in and ‘Insert into’ wins hands down! That’s what happens when you dangle Foxpro problems in this group. It’s like bait we can’t resist! Thanks! Paul Sent from my

Re: Appending from a Cursor

At 06:21 2018-04-12, Alan Bourke wrote: On Thu, 12 Apr 2018, at 1:31 PM, Jean MAURICE wrote: > Hi Gene, > > 'append from' appends data from a file on the disk and a cursor is not a file ! A cursor may or may not have a disk presence depending on various factors. But