Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Select cursors
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00747843
Message ID:
00747846
Vues:
21
In VFP7 add READWRITE clause to SELECT to make cursor read/write. In VFP6 add NOFILTER to make sure that cursor is created as a temp dbf and than reopen it with AGAIN clause.
SELECT ... ;
INTO CURSOR temp NOFILTER
USE ( DBF("temp")) IN 0 AGAIN ALIAS MyReportCursor
USE IN temp 
SELECT MyReportCursor
>I love using the Select ... Into cursor command to create recordsets for reports. Is there any way to have these cursors be read/write like cursors created with the create cursor command? I don't want to update the tables behind the query, just manipulate the cursor a little before calling the report.
>
>Thanks!
--sb--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform