Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updatable Cursors:
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Updatable Cursors:
Divers
Thread ID:
00508483
Message ID:
00508483
Vues:
34
More anomalies?

Is there any way to get the results of a SQL statment into an updatable cursor? We've noticed that if you use SELECT ..... INTO CURSOR, the resultant cursor is read only and can't be updated with INSERT or UPDATE statements.

Cursors created with CREATE CURSOR behave just like tables and can be UPDATED, ALTERED, or INSERTED.

The problem I'm trying to get beyond is the whole issue of temporary files when creating elaborate queries. Ideally, I'd like to use cursors instead of creating tables for queries requiring multiple intermediate steps.

--- L
-- 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