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

Appending from a Cursor

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 select the transaction alias and then do append from (alimport) alimport is an

RE: xBASE Appending from a Cursor

Correct - Brain not engaged here Paul but it was Friday!! Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Paul Newton Sent: 11 July 2016 09:05 To: profox@leafe.com Subject: RE: xBASE Appending from a Cursor I would have suggested INSERT

RE: xBASE Appending from a Cursor

I would have suggested INSERT INTO <> FROM NAME <> rather than APPEND BLANK and GATHER NAME -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Dave Crozier Sent: 08 July 2016 11:07 To: profoxt...@leafe.com Subject: RE: xBASE Appending f

RE: xBASE Appending from a Cursor

the gather. Dave -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: 07 July 2016 19:16 To: ProFox Email List <profox@leafe.com> Subject: Re: xBASE Appending from a Cursor At 16:37 2016-07-06, Gianni Turri <gianni...@gmail.com>

Re: xBASE Appending from a Cursor

At 16:37 2016-07-06, Gianni Turri wrote: On Wed, 06 Jul 2016 15:57:20 -0700, Gene Wirchenko 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

Re: xBASE Appending from a Cursor

On Wed, 06 Jul 2016 15:57:20 -0700, Gene Wirchenko 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

xBASE Appending from a Cursor

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

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

Appending from a Cursor

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 intermediate, and the new structure. the problem is how to copy from one cursor to

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

: Appending from a Cursor 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 intermediate, and the new structure. the problem is how to copy

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