Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>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
Assume the cursor that is the result of your query is named "query". You can write to this cursor by issuing the following command:
USE AGAIN DBF('query') ALIAS whatever
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement