Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sucessive Selection from a cursor
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Sucessive Selection from a cursor
Miscellaneous
Thread ID:
00537538
Message ID:
00537538
Views:
39
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.
Next
Reply
Map
View

Click here to load this message in the networking platform