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: [email protected]
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/[email protected]
** 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.
