Author: desmond.lloyd@gmail.com
Posted: 2013-08-19 at 17:30:33
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.