Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sucessive Selection from a cursor
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Sucessive Selection from a cursor
Divers
Thread ID:
00537538
Message ID:
00537538
Vues:
41
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform