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
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
-
Gene Wirchenko -
Richard Kaye