Hello:
I just wanted to copy some data to a cursor for some
analysis. I prefer a cursor to a table here as it is easier to throw
away. I suppose I could create the cursor and then append into it,
but is there a way to copy to a non-existent cursor which is created
with the same command?
I do not see one. Am I overlooking something?
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/8fb7ab8327d7dba286ee513130690173@mtlp000084
** 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.
Select <fields> from table where <filter> into cursor mycursorname.
If you want to be able to manipulate the cursor by adding or removing rows, adding indexes, etc. use the READWRITE clause.
--
rk
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Gene Wirchenko
Sent: Wednesday, April 12, 2017 5:44 PM
To: profoxtech@leafe.com
Subject: Copying to a Cursor
Hello:
I just wanted to copy some data to a cursor for some
analysis. I prefer a cursor to a table here as it is easier to throw
away. I suppose I could create the cursor and then append into it,
but is there a way to copy to a non-existent cursor which is created
with the same command?
I do not see one. Am I overlooking something?
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/BN4PR10MB0913DF06444AE37169F33A2AD2030@BN4PR10MB0913.namprd10.prod.outlook.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 14:57 2017-04-12, Richard Kaye <rkaye@invaluable.com> wrote:
>Select <fields> from table where <filter> into cursor mycursorname.
>
>If you want to be able to manipulate the cursor by adding or
>removing rows, adding indexes, etc. use the READWRITE clause.
Thank you.
I blindsided myself. I was thinking too much of source and
destination. (A command like
copy to cursor thecursor
would be nice.)
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/4cafcc42d7e83f9a02f93f4c3a06315c@mtlp000085
** 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.