Author: Gene Wirchenko, genew@shuswap.net
Posted: 1999-09-22 19:48:24 Link
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.
Author: Miller, Tony, tmiller@probusiness.com
Posted: 1999-09-22 19:54:05 Link
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.
>
>
Author: Gene Wirchenko, genew@shuswap.net
Posted: 1999-09-22 20:21:58 Link
>USE DBF("CURSORNAME") AGAIN IN 0 ALIAS OTHERNAME
>Othername will now be writeable..
No, the cursor is already writeable. I want to be able to read another
cursor into it. I don't know how to access the other cursor with append from.
[snipped previous]
Sincerely,
Gene Wirchenko
genew@shuswap.net
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
Author: Miller, Tony, tmiller@probusiness.com
Posted: 1999-09-22 20:25:54 Link
Okay.. Append from DBF("OtherCursor'sAlias")
> -----Original Message-----
> From: genew@shuswap.net [SMTP:genew@shuswap.net]
> Sent: Wednesday, September 22, 1999 5:22 PM
> To: Multiple recipients of ProFox
> Subject: RE: Appending from a Cursor
>
> >USE DBF("CURSORNAME") AGAIN IN 0 ALIAS OTHERNAME
> >Othername will now be writeable..
>
> No, the cursor is already writeable. I want to be able to read
> another
> cursor into it. I don't know how to access the other cursor with append
> from.
>
> [snipped previous]
>
> Sincerely,
>
> Gene Wirchenko
> genew@shuswap.net
>
> Computerese Irregular Verb Conjugation:
> I have preferences.
> You have biases.
> He/She has prejudices.
>
>
Author: Gene Wirchenko, genew@shuswap.net
Posted: 1999-09-23 01:56:13 Link
>Okay.. Append from DBF("OtherCursor'sAlias")
Thank you. That was a pleasant help. I knew it was the right thing to
do to take a break!
It was especially nice to get an elegant solution as after my first
post, I discovered that copy to array does not automatically size the array
if the array is local. It does if it's private, but I try avoid those.
[snipped previous]
Sincerely,
Gene Wirchenko
genew@shuswap.net
Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.
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 another.
I do something like:
select cursor1
append from (oldtablename)
select cursor2
append from _____
What goes in the blank? Simply the cursor name gets interpreted as a
filename. How do I specify that it is a cursor? "copy to" will
overwrite the structure. I create cursors because I want to specify
the structure.
Normally, this situation does not come up, because I am adding
columns. In this case, I am renaming so I have to stage this a bit.
Yes, I could use a temporary table, but I would rather not as
the code will not be running on my system. (I like to tread as
gently as I can on others' systems.)
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
To append directly from a cursor use: append from dbf('cCursorName')
----
Michael Oke, II
okeind@gmail.com
661-349-6221
On Aug 19, 2013, at 3:26 PM, Gene Wirchenko <genew@telus.net> 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 intermediate, and the new structure. the problem is how to copy from one cursor to another.
>
> I do something like:
> select cursor1
> append from (oldtablename)
> select cursor2
> append from _____
> What goes in the blank? Simply the cursor name gets interpreted as a filename. How do I specify that it is a cursor? "copy to" will overwrite the structure. I create cursors because I want to specify the structure.
>
> Normally, this situation does not come up, because I am adding columns. In this case, I am renaming so I have to stage this a bit.
>
> Yes, I could use a temporary table, but I would rather not as the code will not be running on my system. (I like to tread as gently as I can on others' systems.)
>
> Sincerely,
>
> Gene Wirchenko
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/A9CEF068-ECED-4EBA-9CF1-16B974EC6212@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Append from dbf('cursor name')?
Desmond
Sent via BlackBerry by AT&T
-----Original Message-----
From: Gene Wirchenko <genew@telus.net>
Sender: "ProFox" <profox-bounces@leafe.com>
Date: Mon, 19 Aug 2013 15:26:32
To: ProFox Email List<profox@leafe.com>
Reply-To: ProFox Email List <profox@leafe.com>
Subject: 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 another.
I do something like:
select cursor1
append from (oldtablename)
select cursor2
append from _____
What goes in the blank? Simply the cursor name gets interpreted as a
filename. How do I specify that it is a cursor? "copy to" will
overwrite the structure. I create cursors because I want to specify
the structure.
Normally, this situation does not come up, because I am adding
columns. In this case, I am renaming so I have to stage this a bit.
Yes, I could use a temporary table, but I would rather not as
the code will not be running on my system. (I like to tread as
gently as I can on others' systems.)
Sincerely,
Gene Wirchenko
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
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
> intermediate, and the new structure. the problem is how to copy from
> one cursor to another.
>
> I do something like:
> select cursor1
> append from (oldtablename)
> select cursor2
> append from _____
> What goes in the blank? Simply the cursor name gets interpreted as a
> filename. How do I specify that it is a cursor? "copy to" will
> overwrite the structure. I create cursors because I want to specify the
> structure.
>
> Normally, this situation does not come up, because I am adding
> columns. In this case, I am renaming so I have to stage this a bit.
>
> Yes, I could use a temporary table, but I would rather not as the
> code will not be running on my system. (I like to tread as gently as I
> can on others' systems.)
>
> Sincerely,
>
> Gene Wirchenko
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/52129D31.8030204@san.rr.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
At 15:29 2013-08-19, "Michael Oke, II" <okeind@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 Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.