Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Using Cursors in a report
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00114725
Message ID:
00114730
Vues:
17
>Before I generate my report, I do some queries using SQL SELECT, and I save the results into Cursors. How do I use these cursors in my report? I couldn't just "add" a cursor to the Data Environment of the report. I tried to go around this by Writing my queries to tables, adding those tables to the DE, and then rewriting code so the query results are going into CURSORS again. However, the added table in the DE must have an INDEX to be able to set a relation between it and the other report table, and I cann't have an index with a CURSOR. Does this mean I should use tables instead of CURSORS?
>

You can do your SQL statements to create your cursors in the init method of the dataenvironment. Then ensure the field names don't have an alias on the report.

With this method, you don't have to add the cursors to the dataenvironment (you can do this anyway) they are created when the report is run or previewed.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform