Hi....I'm trying to do a series of selections into intermediate cursors, and I got this interesting error:
===============
"cursor" must be created with SELECT ... INTO TABLE (Error 1815)
You have tried to use a repackaged cursor as a source for another SELECT statement.
Some cursors cannot be used in successive queries.
Use the INTO TABLE clause of the SELECT - SQL statement instead.
===============
What is a "repackaged" cursor?
What I'd like is to use these instead of tables, so I don't have to worry about cleaning up after myself. (typical....eh?)
SELECT * from Blah;
INTO CURSOR curBlah
SELECT * from curBlah;
INTO CURSOR newCurBlah;
Etc.
Thanks.
---- Larry
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.