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

Re: Appending from a Cursor

nd third parties and properly stored > protected and insured and identified as the seller's property but shall be > entitled to resell or use the goods in the ordinary course of its business. > Until such time as the property in the goods passes to the buyer the seller > shall be ent

RE: Appending from a Cursor

ril 12, 2018 9:30 AM To: profoxt...@leafe.com Subject: 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 f

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

: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, April 12, 2018 6:18 AM To: profoxt...@leafe.com Subject: Re: Appending from a Cursor On Wed, Apr 11, 2018 at 8:31 PM, Gene Wirchenko <ge...@telus.net> wrote: > > I am puzzled why (alimport) works

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

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 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

ready have it open. > > -- > > rk > > -Original Message- > From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Gene > Wirchenko > Sent: Wednesday, April 11, 2018 8:32 PM > To: profoxt...@leafe.com > Subject: RE: Appending from a Cursor > > A

RE: Appending from a Cursor

Message- From: ProfoxTech <profoxtech-boun...@leafe.com> On Behalf Of Gene Wirchenko Sent: Wednesday, April 11, 2018 8:32 PM To: profoxt...@leafe.com Subject: RE: Appending from a Cursor At 11:10 2018-04-11, "John Weller" <j...@johnweller.co.uk> wrote: >You could try &g

RE: Appending from a Cursor

At 11:10 2018-04-11, "John Weller" wrote: You could try APPEND FROM DBF(alimport) [whack object="hand" target="forehead"] I have used it in the past, just not very often. When I checked my code, I searched for "append from (" instead of just "append from".

RE: Appending from a Cursor

You could try APPEND FROM DBF(alimport) John John Weller 01380 723235 07976 393631 > 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 them to the transaction table. I

Re: Appending from a Cursor

append from (dbf(alimport)) Append from expects a file Thierry Nivelet http://foxincloud.com/ Give your VFP app a second life in the cloud > Le 11 avr. 2018 à 20:03, Gene Wirchenko a écrit : > > append from (alimport) ___ Post

Re: Appending from a Cursor

At 07:55 2013-09-03,Lew Schwartz lew1...@gmail.com wrote: Have to match? You can include constants, variables and data from other cursors to make the columns match up. It's a code issue, not data. I got it working with append from dbf(cursorname). Using the SQL solution, I would

Re: Appending from a Cursor

Have to match? You can include constants, variables and data from other cursors to make the columns match up. It's a code issue, not data. -Lew Schwartz On Mon, Aug 26, 2013 at 2:16 PM, Gene Wirchenko ge...@telus.net wrote: At 06:45 2013-08-25, Lew Schwartz lew1...@gmail.com wrote: I don't

Re: Appending from a Cursor

At 06:45 2013-08-25, Lew Schwartz lew1...@gmail.com wrote: I don't think that will work all the time. A cursor may be a sql filtered, behind the scenes view of a dbf. If you append from the actual dbf, you'll lose the filter. The problem is mixing the legacy dml with sql; they don't think of

Re: Appending from a Cursor

I don't think that will work all the time. A cursor may be a sql filtered, behind the scenes view of a dbf. If you append from the actual dbf, you'll lose the filter. The problem is mixing the legacy dml with sql; they don't think of data in exactly the same way. I believe, but don't have time to

Re: Appending from a Cursor

You could always create a small program to test it. It will work, unless some detail was not mentioned by the original question! There is always a workaround! On Sun, Aug 25, 2013 at 9:45 PM, Lew Schwartz lew1...@gmail.com wrote: I don't think that will work all the time. A cursor may be a sql

Re: Appending from a Cursor

At 15:29 2013-08-19, Michael Oke, II oke...@gmail.com wrote: To append directly from a cursor use: append from dbf('cCursorName') Thank you. That did it. [snip] Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription

Re: Appending from a Cursor

To append directly from a cursor use: append from dbf('cCursorName') Michael Oke, II oke...@gmail.com 661-349-6221 On Aug 19, 2013, at 3:26 PM, Gene Wirchenko ge...@telus.net wrote: Dear Vixens and Reynards: How do I append from a cursor? I am modifying a table structure,

Re: Appending from a Cursor

Append from dbf('cursor name')? Desmond Sent via BlackBerry by ATT -Original Message- From: Gene Wirchenko ge...@telus.net Sender: ProFox profox-boun...@leafe.com Date: Mon, 19 Aug 2013 15:26:32 To: ProFox Email Listprofox@leafe.com Reply-To: ProFox Email List profox@leafe.com Subject:

Re: Appending from a Cursor

Gene, append from dbf(cursor1) Dan On 08/19/13 03:26 PM, Gene Wirchenko wrote: Dear Vixens and Reynards: How do I append from a cursor? I am modifying a table structure, but I am renaming some columns. I have set up three cursors (using create cursor) with the old, an