To append directly from a cursor use: append from dbf('cCursorName')
----
Michael Oke, II
[email protected]
661-349-6221
On Aug 19, 2013, at 3:26 PM, Gene Wirchenko <[email protected]> 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.
