RE: Appending from a Cursor

Author: Miller, Tony, tmiller@probusiness.com

Posted: 1999-09-22 at 19:54:05

USE DBF("CURSORNAME") AGAIN IN 0 ALIAS OTHERNAME

Othername will now be writeable..

> -----Original Message-----

> From: genew@shuswap.net [SMTP:genew@shuswap.net]

> Sent: Wednesday, September 22, 1999 4:48 PM

> To: Multiple recipients of ProFox

> Subject: VFP: Appending from a Cursor

>

> I have a cursor that I wish to update with the contents of another

> cursor. I am replacing records that are for one client only. How do I do

> it?

>

> I'd like to be able to use something like

> select (aliasdest)

> delete for clcode=who

> append from (aliassource) && The culprit!

> but it looks as if I will have to code

> select (aliassource)

> copy to array therecords

> select (aliasdest)

> delete for clcode=who

> append from array therecords

>

> Is there something better? I'd like to cut out the middleman (the

> array) here. Cursor (aliasdest) must remain writeable.

>

> Sincerely,

>

> Gene Wirchenko

> genew@shuswap.net

>

> Computerese Irregular Verb Conjugation:

> I have preferences.

> You have biases.

> He/She has prejudices.

>

>

©1999 Miller, Tony, tmiller@probusiness.com